handling loop exception in an anonymous block
515837Jun 29 2006 — edited Jun 30 2006hI ,
I have a an anonymous block
----------------------
declare
cursor
local variables
begin
open cursor
some statements
loop
some statement ;
some othet statement;
select something from sometablein local variable where some field = cursor.value ;
some more statements
end loop
some more statements
exception
when whatever
then whatever
end;
/
------------------------------------------------------
Now my select statement may give a NO_DATA_FOUND error which i want to catch and ignore .
Pls tell me how to do it.