How to use Multiple Cursor Output values from procedure(package) in asp.net

Question

Procedure GetDetails( ID as Varchar2,
                       Cursor1 OUT Cursor_Type,
                        Cursor1 OUT Cursor_Type ) AS

BEGIN

       OPEN CURSOR1 FOR 
              Select Name from User where UserID=ID;

       OPEN CURSOR2 FOR 
               Select Place from Dept where DeptID=ID;

END GetDetails;

How can I use Name & place values from 2 cursors?

Use refcursors Using a ref cursor as input type with ODP.NET — Sathyajith Bhat
– Sathyajith Bhat, Commented Apr 28, 2012 at 17:08

John Fisher · Accepted Answer · 2012-05-10 17:10:31Z

3

Try using DataReader.NextResult to move to the next cursor. For example:

while (dr.Read())
{
  //first cursor goes here
}
if (dr.NextResult() == true)
{
  while (dr.Read())
  {
    //Second cursor goes here
  }
}

edited May 10, 2012 at 17:10

John Fisher

22.8k2 gold badges43 silver badges67 bronze badges

answered May 10, 2012 at 10:58

PANKAJ

1531 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use Multiple Cursor Output values from procedure(package) in asp.net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related