Page 1 of 1

Calling Stored Procedure with in Stroed procedure

PostPosted: Thu Sep 03, 2015 6:45 pm
by gauravfrankly
Hi All,
I have following case:
Team A will call the Stored procedure SP1.
SP1 will call the SP2.
In SP2 will OPEN a cursor and want resultset of this cursor to send to TEAMA as response to their call made to SP1.
SP1 and SP2 are Native DB2 Stored Procedures.

Please suggest approch to do this.