From oracle-l-bounce@freelists.org Thu Sep 22 15:22:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8MKMKes007526 for ; Thu, 22 Sep 2005 15:22:20 -0500 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 j8MKM86H007494 for ; Thu, 22 Sep 2005 15:22:09 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 786751EEC83; Thu, 22 Sep 2005 15:19:18 -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 10003-09; Thu, 22 Sep 2005 15:19:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ECE7C1EE56B; Thu, 22 Sep 2005 15:19:17 -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:references; b=Vx4/+dGwxD25+eSFk09OJ1ZydrJSTnFxiB41J/OA2hlkCwRfHJDPgonhHTTwwtp9OH6rVa0QPqC7OO/K6wPl552Toqt2vP4uTM79eBqyVL9RlU6zwyPI6+1cvYRzNmQ6BF6vXCxpcS+/iVbDi05xKjb+qTH5AhTHx59zfRCqxH0= Message-ID: Date: Thu, 22 Sep 2005 15:17:11 -0500 From: Greg Norris To: ryan_gaffuri@comcast.net Subject: Re: is this documented? Cc: oracle-l@freelists.org In-Reply-To: <092220052005.29403.43330EA10005BD9C000072DB2200734364079D9A00000E09A1020E979D@comcast.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11706_31596220.1127420231873" References: <092220052005.29403.43330EA10005BD9C000072DB2200734364079D9A00000E09A1020E979D@comcast.net> X-archive-position: 25809 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: spikey.mcmarbles@gmail.com Precedence: normal Reply-To: spikey.mcmarbles@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.1 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, NORMAL_HTTP_TO_IP autolearn=no version=2.63 ------=_Part_11706_31596220.1127420231873 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yes, this is documented behaviour... I don't have the docs easily accessibl= e at the moment, or I'd give you a specific pointer. You can work around it b= y changing the EXIT portion to: exit when l_plsqltable.COUNT =3D 0; On 9/22/05, ryan_gaffuri@comcast.net wrote: > > I may have just missed it in the docs or someone wrote it somewhere... > just wondering if anyone else has seen this. > > DB 9.2.0.6 > > easiest to explain with pseudo-code > > open cursor; > loop > > fetch cursor bulk collect into l_plsqltable limit 100; > > ... do stuff > > exit when cursor%notfound; > > end loop; > > close cursor; > > end; > -- "I'm too sexy for my code." - Awk Sed Fred. ------=_Part_11706_31596220.1127420231873 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yes, this is documented behaviour... I don't have the docs easily accessible at the moment, or I'd give you a specific pointer.  You can work around it by changing the EXIT portion to:

   exit when l_plsqltable.COUNT =3D 0;


On 9/22/05, ryan_gaffuri@comcast.ne= t <ryan_gaffuri@comc= ast.net > wrote:

I may have just missed it in the docs or someone wrote it somewhere... j= ust wondering if anyone else has seen this.

DB 9.2.0.6

easiest to explain with pseudo-code

open cursor;
     loop

      fetch cursor bulk collect into l_plsqltab= le limit 100;

     ... do stuff

  exit when cursor%notfound;

end loop;

close cursor;

end;


--
"I'm too sexy for my code.&qu= ot; - Awk Sed Fred.
------=_Part_11706_31596220.1127420231873-- -- http://www.freelists.org/webpage/oracle-l