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@xxxxxxxxx> 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@xxxxxxxxxxx <ryan_gaffuri@xxxxxxxxxxx > wrote: > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l