I have a Stored Procedure that returns a datatable.
How do I call that Store Procedure within another Stored Procedure?
Here is what I have so far:
DROP PROCEDURE PC_KI_KINSHIPGENERALINFO.SpTestItNow!
CREATE PROCEDURE PC_KI_KINSHIPGENERALINFO.SpTestItNow( IN p_RSRC_ID FLOAT)
SPECIFIC PC_KI_KINSHIPGENERALINFO.SpTestItNow
LANGUAGE SQL
DYNAMIC RESULT SETS 1
BEGIN P2 :
BEGIN
Declare c_Return Cursor With Return to CLIENT For
--Call PC_KI_KINSHIPGENERALINFO.SpCheckProviderBackground(p_RSRC_ID);
Open c_Return;
END P2;
END!