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.

Skip LOOP iteration when package variable changes

Sergio VegaOct 20 2015 — edited Oct 21 2015

Hi,

I have a package with a procedure to process some records. Inside this procedure I have private functions and procedures that I use inside a loop. I would to know if is possible to skip an iteration when any of the code inside of the loop set a session variable to FALSE.

Below is an example of the code I would like to use. Maybe this can be solved using WHILE?

Database version: 10g

Thanks for your response or any suggestion that can help me solve this.

Sergio

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2015

Added on Oct 20 2015

9 comments

1,299 views