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.
cts_teamboAsked:
Who is Participating?
 
leonstrykerConnect With a Mentor Commented:
This will show you how to handle multiple recordset:

http://www.4guysfromrolla.com/webtech/083101-1.shtml

Leon
0
 
JR2003Connect With a Mentor Commented:
You can copy a recordset to a disconnected recordset.
http://vbforums.com/showthread.php?p=2263813

You use the .NextRecordset  function to move to the next recordset.
0
 
cts_teamboAuthor Commented:
The examples given in the above websites are for SQL server.
0
 
leonstrykerCommented:
So what?  Once the data is in the recordset object it is exactly the same.
0
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.