PL-SQL: Exception NO_DATA_FOUND or %NOTFOUND

From: Henk Hultink <hhu_at_stopspam.stoas.nl>
Date: Fri, 5 Jul 2002 14:30:43 +0200
Message-ID: <3d259174$1_at_news.wau.nl>



Hi,

[Quoted] [Quoted] 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

....

[Quoted] [Quoted] I remember having heard that thers IS a difference; however I can't find it in the manuals.

[Quoted] Regards,

--
H. Hultink
[Quoted] 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 - 14:30:43 CEST

Original text of this message