Handling an insert/update statements from error/exception
539772Jul 11 2008 — edited Jul 11 2008Hi all,
I have a procedure where I need to insert/update data into 5 tables by using 5 different insert statements. if any insert/update statement fails due to error/exception then it should not impact/terminate the program and still need to execute next insert/update statement. The following is an example
begin
insert statement 1;
--If above statement fails due to error/exception still need to execute the below statements and the same condition for all the below statement
update statement 2;
Inser statement 3;
Insert statement 4;
end;
Any help would be more appreciated.