Topic
No replies
neilpitman
neilpitman
1 Post
ACCEPTED ANSWER

Pinned topic Using curor marked "WITH RETURN TO CLIENT" in a stored procedure

‏2013-09-18T20:12:46Z |

I have to use a  DB2 stored procedure that returns results with a cursor defined as "WITH RETURN TO CLIENT".  I do not have control over this SP so I cannot "just" change the cursor to "WITH RETURN TO CALLER"; (anyways, this would change the procedure profoundly).  I need to access the cursor from another stored procedure (for massive testing purposes).  The cursor is invisible because it is to be passed through to the client.  Do you have any idea how to obtain access to this cursor from within a stored proc?