Re: is there a way to return multiple cursors from a query
- From: Richard Ji <richard.c.ji@xxxxxxxxx>
- To: kduret@xxxxxxxxxxxxxxxxxxxx
- Date: Thu, 3 Feb 2005 00:50:02 -0500
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@xxxxxxxxxxxxxxxxxxxx> 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.
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
