Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Handling multiple oracle refcursors in vb

Posted on 2006-10-24
8
Medium Priority
?
420 Views
Last Modified: 2012-08-14
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
Comment
Question by:cts_teambo
8 Comments
 
LVL 21

Accepted Solution

by:
oleggold earned 272 total points
ID: 17798100
0
 
LVL 29

Assisted Solution

by:leonstryker
leonstryker earned 264 total points
ID: 17798226
This will show you how to handle multiple recordset:

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

Leon
0
 
LVL 18

Assisted Solution

by:JR2003
JR2003 earned 264 total points
ID: 17798752
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
 

Author Comment

by:cts_teambo
ID: 17825020
The examples given in the above websites are for SQL server.
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 17833929
So what?  Once the data is in the recordset object it is exactly the same.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question