From oracle-l-bounce@freelists.org Thu Feb 3 00:52:38 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j136qcdo009523 for ; Thu, 3 Feb 2005 00:52:38 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j136qbem009519 for ; Thu, 3 Feb 2005 00:52:37 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7CC2FD463; Thu, 3 Feb 2005 00:51:41 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15047-02; Thu, 3 Feb 2005 00:51:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 062C769766; Thu, 3 Feb 2005 00:51:40 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=YqPosEInaNld8VTGdHqHzCvI67bqhWhB6K65fTH5pOgdnp22Zy98dWGQs94/rofLCftq8biFQ8NJ1iJatALBBo2GgcLxXi36+9tKK5NqAxRpQNP1n8YujoYE3Y8U+QlD8xxuoiAHaJEwl9yyr0JMZr+NoyvNbQafjqDvUZQFJRw= Message-ID: Date: Thu, 3 Feb 2005 00:50:02 -0500 From: Richard Ji To: kduret@starkinvestments.com Subject: Re: is there a way to return multiple cursors from a query Cc: "Oracle L (E-mail)" In-Reply-To: <5EAB052DE9A3BD4D84E6AE8EE3CCA7E5B7EEA7@sneetch.ad.starkinvestments.com> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <5EAB052DE9A3BD4D84E6AE8EE3CCA7E5B7EEA7@sneetch.ad.starkinvestments.com> X-archive-position: 15730 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: richard.c.ji@gmail.com Precedence: normal Reply-To: richard.c.ji@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: 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. > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l