I have two procedures (P1 & P2). P1 returns 1 result set of Subscriber ID (and can be called standalone).
P2 calls P1 to use the result set to create result set 2 (Subscriber Eligibility) and result set 3 (Subscriber profile). Retrieval of the two result 2 & 3 set is fine, but I don't know how to access result SET 1 for P1 to return to caller.
P2 calls P1 to use the result set to create result set 2 (Subscriber Eligibility) and result set 3 (Subscriber profile). Retrieval of the two result 2 & 3 set is fine, but I don't know how to access result SET 1 for P1 to return to caller.