• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

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.
0
cts_teambo
Asked:
cts_teambo
3 Solutions
 
oleggoldCommented:
0
 
leonstrykerCommented:
This will show you how to handle multiple recordset:

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

Leon
0
 
JR2003Commented:
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now