Skip to Main Content

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!

Continue loop even if it fails during one of the delete statement

user6314670May 16 2016 — edited May 16 2016

Hi All, I have to purge data from around 70 tables and no one is aware the data flow because of which I am facing many issues during data deletion. Prepared the script based on constraints and the information received but my script is getting failed and one main reason is some child tables have 2 to 4 parent tables. I am using FOR loop (have two more FOR loop inside main loop) and committing records every 100 records. In-case any record fails then I want to log that failed record in temporary table and continue to purge to second one. So, how I can rollback that particular failed record and commit the rest. Thanks in advance for the help.

This post has been answered by Paulzip on May 16 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2016
Added on May 16 2016
5 comments
790 views