What is the difference between NO DATA FOUND and %NOTFOUND ?

Sheetal

Aug 24th, 2006

NO_DATA_FOUND is system defined exception. This is generated when no rows selected.
%NOTFOUND is attribute which is used with cursor. If cursor returns no row then %NOTFOUND returns true and if returns row then %NOTFOUND is false.

Madhuri

Feb 7th, 2007

NO_DATA_FOUND is raised when select statement of pl/sql block does not return any rows.%NOTFOUND is raised when select statement of cursor does not return any rows.

BASAVARAJ KOLUR

Mar 8th, 2007

i think maduri ans is wrong..

no_data_found is oracle predefined exception it raises when select stament no able to fetch row from table then no_data_found exception raises

%notfound is cursor attribute. in case of update and delete statement when rows not matched for updation and delete then that time cursor%not found attribute becomes true otherwise it become false

when no_data_found arises controll immeditily goes to exception section but in case of %notfound controll not goes to exception section

Mohan

Apr 7th, 2007

NO_DATA_FOUND is an oracle predefined expection. We can use it whenever the sql statements don't return any rows within the pl/sql block.

%NOTFOUND is an attribute returns boolean for both explicit and implicit cursors, this can be used when the recent sql statements don't affect any rows i.e., even if we have given insert or update or delete or pl/sql select within the block, it doesn't affect any single row means the cursor cannot be found...

jagadeesh9
Profile Answers by jagadeesh9 Questions by jagadeesh9

Feb 22nd, 2008

% not found is a cursor attribute if the cursor is not open set as a true.
where as in NO_DATA_FOUND if select statement doesn't return any row it will raise the NO_DATA_FOUND