Skip to Main Content
Forums

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!

Skip error and continue the pl/sql block

KODSApr 15 2013 — edited Apr 15 2013
Dear All,

Please help me in fixing the below scenario.

I got a requirement to write a pl/sql which will handle update statements.

For example :
A table containing 10 rows of data. Through pl/SQL block I am updating the 10 rows (or less number of rows).
Now the scenario is while updating the record/row 4th, oracle encountered an error and then oracle exit from pl/sql block and roll back the transaction.

My requirement here is, while updating the records, if oracle encounter any error it should throw an error or skip the record and continue in processing the records. Oracle should not come out of pl/sql block.

We are using oracle 10g.

Thanks,
KODS
This post has been answered by jeneesh on Apr 15 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2013
Added on Apr 15 2013
#9i, #plsql
6 comments
3,900 views