Hi,

I need a clarification regarding the result set returned by a stored procedure.

Assume that i ve stored procedures AA and BB. Let BB returns a resultset ie.. it has a cursor defined in it and has some values collected in it during the execution of the procedure.

I call the procedure BB from AA and I want to store those values returned by the procedure BB in a table, i use ' Associate result locators' and 'Allocate cursor' in the calling procedure AA. from the allocated cursor i fetch the values and then insert them in to the table.

is there any simple way to do this...

regards,
Sn

this is the easiest way todo.. even to get from sysproc sp we use this kind of code and never had a problem..