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