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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to Continue cursor loop after exception?

593881Aug 20 2007 — edited Aug 20 2007
hi,

I am quite new to PL SQL. I need to select data from a table , process the dates (which are in string format) and then copy data to another table. I am using cursor , processing each row at a time. if the string data (to be converted into date) is not in proper fomat ( sometimes N/A, sometimes blank) then sql raises an exception where i assign default date.
when the exception is raised how to continue with the next row. 'coz when an excpetion is occuring the whole procedure stops and does not move to next table row.

Can anyone help me with this?
Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2007
Added on Aug 20 2007
7 comments
14,799 views