Re: is this documented?

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: