Posted: Thu Jan 07, 2010 1:47 pm Post subject: Oracle Stored Procedure Twist...
Centurion
Joined: 09 Oct 2002 Posts: 145 Location: Florida
The Oracle DBA has created an SP that returns a cursor. No issues there. Pretty straightforward.
The twist is that they want me to then call another SP and pass in the cursor, so that they can close it. It sounds a bit convoluted to me, but anyway...
I have a sneaky hunch that it can't be done, but is always worthwhile to let you wizards weigh in on it.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum