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_at_comcast.net <ryan_gaffuri_at_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 <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.

--
http://www.freelists.org/webpage/oracle-l