Toad World® Forums

How to call a Proc that returns a dataset from within another Proc.

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!