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

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

Jon Knight

 -----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
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.
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 15 2005 - 12:27:16 CST