Another way to correct this is to move the 'exit when cursor%notfound'
line to where it belongs - directly following the fetch statement.
On 9/22/05, Greg Norris <spikey.mcmarbles_at_gmail.com> wrote:
> 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:
> >
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 26 2005 - 12:42:50 CDT
