RE: is there a way to return multiple cursors from a query

  • From: "Knight, Jon" <jknight@xxxxxxxxxxxxxx>
  • To: "'kduret@xxxxxxxxxxxxxxxxxxxx'" <kduret@xxxxxxxxxxxxxxxxxxxx>, "Oracle L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 15 Feb 2005 11:24:23 -0600

I understand the "emergency" routine all too well.  Thanks for the info.

Jon Knight


 -----Original Message-----
From:   oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Duret, Kathy
Sent:   Tuesday, February 15, 2005 11:11 AM
To:     Oracle L (E-mail)
Subject:        RE: is there a way to return multiple cursors from a query


Well yes and no.

I fixed the problem with a different join on the second procedure that =
is called so I didn't need to do two cursors.

I was able to return two cursors, but I never was successful at =
manipulating the child calling the parent to return what I wanted.  I =
was trying to resolve and post it but unfortunately it is not going to =
happen in the near future.

Most the people here were correct... return it in one pass but I =
unfortunately changing the UI was very difficult.

Part of my problem was that I needed to use ... in out in the parameter =
specification.

If I do get this working, I will post it but it won't be for awhile.... =
in the middle of about 5 "emergency" requests.

Kathy


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Knight, Jon
Sent: Tuesday, February 15, 2005 10:45 AM
To: Duret, Kathy; Oracle L (E-mail)
Subject: RE: is there a way to return multiple cursors from a query


Kathy,
  Did you ever find a solution?

Jon Knight

 -----Original Message-----
From:   oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Duret, Kathy
Sent:   Wednesday, February 02, 2005 4:59 PM
To:     Oracle L (E-mail)
Subject:        RE: is there a way to return multiple cursors from a query



I am opening up a tar with metalink.....

I can't seem to get the uncontained cursor right and keep running into
pl/sql 00382 error...

Will keep you posted.

Kathy



This transmission contains information solely for intended recipient and =
may
be privileged, confidential and/or otherwise protect from disclosure.  =
If
you are not the intended recipient, please contact the sender and delete =
all
copies of this transmission.  This message and/or the materials =
contained
herein are not an offer to sell, or a solicitation of an offer to buy, =
any
securities or other instruments.  The information has been obtained or
derived from sources believed by us to be reliable, but we do not =
represent
that it is accurate or complete.  Any opinions or estimates contained in
this information constitute our judgment as of this date and are subject =
to
change without notice.  Any information you share with us will be used =
in
the operation of our business, and we do not request and do not want any
material, nonpublic information. Absent an express prior written =
agreement,
we are not agreeing to treat any information confidentially and will use =
any
and all information and reserve the right to publish or disclose any
information you share with us.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: