Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: is there a way to return multiple cursors from a query

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

From: Richard Ji <>
Date: Thu, 3 Feb 2005 00:50:02 -0500
Message-ID: <>

Will a cursor within a cursor give you what you wanted? I know what you wanted two out ref cursor, but something like this open x for 'select deptno, cursor(select ename from emp where deptno=dept.deptno)
from dept'

will give you the parent/detail in two cursors. Isn't that what you are looking for?

HTH Richard Ji

On Wed, 2 Feb 2005 16:58:37 -0600, Duret, Kathy <> wrote:
> 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.
> --

Received on Thu Feb 03 2005 - 00:52:38 CST

Original text of this message