Dear gurus !
I'm wondering whtether i can catch an SQL error (from inside a PL/SQL proc)
without jumping to the EXCEPTION block
OR
is there a way to jump back to the body of the proc from the EXCEPTION block
(i know that GOTO can not do it).
For example , assume i have users with IDs 1,2,5,6 in
many ways to do that ,
you can put begin .. end block around select .. inside while condition
i := 1;
while i 10 loop
Begin
select the_name from the_table into myvar where the_id = 1;
Exception
when no data found then
null;
End ;
end loop;
or