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!

question about loops

user457357Apr 13 2007 — edited Apr 16 2007
I was wondering how i could re-enter into a loop when a not_data_found exception is thrown.
In my code i open a cursor and loop through the results. The only problem is that i do not know how to handle a no_data_found exception correctly. I would like to ignore this exception and advance the cursor to the next record and continue on within the loop.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2007
Added on Apr 13 2007
13 comments
490 views