Re: PL-SQL: Exception NO_DATA_FOUND or %NOTFOUND

why don't you just simply try it out ?

which I'm sure would answer your question does a cursor fetch raise an exception ?

"Henk Hultink" <hhu_at_stopspam.stoas.nl> wrote in message news:3d259174$1_at_news.wau.nl...
> Hi,
>
> Does anyone know if there is a difference
between:
>
> OPEN <cursor>;
> FETCH <cursor> INTO <variable>;
> EXCEPTION
> WHEN NO_DATA_FOUND THEN
> ....
>
> and
>
> OPEN <cursor>;
> FETCH <cursor> INTO <variable>;
> WHEN <cursor>%NOTFOUND THEN
> ....
>
> I remember having heard that thers IS a
difference; however I can't find it
> in the manuals.
>
> Regards,
> --
> H. Hultink
> Software Engineer
> Stoas, Division IOAL
> Wageningen, The Netherlands
> "Activating Knowledge"
> http://www.stoas.nl
>
> e-mail: hhu_at_stopspam.stoas.nl
>
>
Received on Fri Jul 05 2002 - 15:55:27 CEST