Handling multiple oracle refcursors in vb

Hi All,

I have an oracle procedure returning three ref cursors.  I have to call the procedure from vb and hold the output in three different recordset object.  How is it possible?  Please share the code snippet with me.

I have searched EE, there are examples for handling one refcursor.  But I am unable to tweak that code for my requirement.
Who is Participating?
leonstrykerConnect With a Mentor Commented:
This will show you how to handle multiple recordset:


JR2003Connect With a Mentor Commented:
You can copy a recordset to a disconnected recordset.

You use the .NextRecordset  function to move to the next recordset.
cts_teamboAuthor Commented:
The examples given in the above websites are for SQL server.
So what?  Once the data is in the recordset object it is exactly the same.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.