Doubt regarding EXCEPTIONS
Hello, As the basic flow of a pl/sql block that contains a pl/sql block is like .... Suppose we have an anynomous block of code --------------------------------------------------------------------------------
Begin
....
....
insert;
update;
delete;
EXCEPTION ------Exceptions handled;
END;
/ -------------------------------------------------------------------------------- Now ...i know that all the DML's is goin to execute in a sequence. Now if my insert fails ..the 'update' & 'delete' .stmnts does not execute ... & the Control is passed to the Exception Block; But suppose ... if the Error occured in an Insert statement...But still i want to Execute the Update & delete dml's ..then what to do ....because ..once the Control passes to the exception block ..it will not come back to the 'EXECUTION' section.
Software/Hardware used:
xp
Begin
....
....
insert;
update;
delete;
EXCEPTION ------Exceptions handled;
END;
/ -------------------------------------------------------------------------------- Now ...i know that all the DML's is goin to execute in a sequence. Now if my insert fails ..the 'update' & 'delete' .stmnts does not execute ... & the Control is passed to the Exception Block; But suppose ... if the Error occured in an Insert statement...But still i want to Execute the Update & delete dml's ..then what to do ....because ..once the Control passes to the exception block ..it will not come back to the 'EXECUTION' section.
Software/Hardware used:
xp
ASKED:
March 25, 2010 8:51 PM
UPDATED:
March 25, 2010 9:37 PM
Answer Wiki:
You would have to use a separate exception handler for the INSERT statement.
Something like this:
<pre>BEGIN
....
....
<b> BEGIN
insert;
EXCEPTION
-- do something
END; </b>
update;
delete;
EXCEPTION
...
END;</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
