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

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 <kduret_at_starkinvestments.com> 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.
> --
> http://www.freelists.org/webpage/oracle-l
>

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