Re: is this documented?
- From: Greg Norris <spikey.mcmarbles@xxxxxxxxx>
- To: ryan_gaffuri@xxxxxxxxxxx
- Date: Thu, 22 Sep 2005 15:17:11 -0500
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 = 0;
On 9/22/05, ryan_gaffuri@xxxxxxxxxxx <ryan_gaffuri@xxxxxxxxxxx> 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 <http://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.
Other related posts:
