Hi all,
Consider this sample block structure below in our organnization.
Begin
Update table1
set col1=100
where id=100;
Exception
When others then
v_error_code :=1
v_error_msg := 'Error while updateing table1 '||sqlerrm;
End;
/
Why do we need an exception handling section in update/insert etc. What kind of common errors are encountered in an update exception handler section?
Thanks
Gautam