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,
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.nlReceived on Fri Jul 05 2002 - 14:30:43 CEST