SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Handle error on delete

1D10TApr 10 2013 — edited Apr 10 2013

Hi,

I have some 50 Delete statements in simple SQL, like

BEGIN
DECLARE
DELETE FROM where x=1;
DELETE FROM where x=2;
DELETE FROM where x=3;
.....
exception when others
then
dbms_output.put_line(sqlcode);
raise;

END;

now on error script is stoping but it is incorect :( i want to view the error in which delete it was , but scipt need to go to end !

Any help please !!!

THANKS!
ID.

Edited by: 1D10T on Apr 10, 2013 1:06 AM

Edited by: 1D10T on Apr 10, 2013 1:06 AM

Edited by: 1D10T on Apr 10, 2013 1:07 AM

Edited by: 1D10T on Apr 10, 2013 1:07 AM

This post has been answered by JustinCave on Apr 10 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2013

Added on Apr 10 2013

9 comments

1,790 views