Re: Question about loop conditions

amerar_at_iwc.net wrote:
> Hi,
>
> When you have a loop and use the "EXIT WHEN" clause, can you use it
> more than once? What if you have multiple places in the code where
> you might want to exit?
>
> LOOP
> v_position := INSTR(v_expression,','); --- Want to exit here if
> v_position = 0;
> v_numbers(v_sub) := SUBSTR(v_expression,1,v_position-1);
> v_expression := SUBSTR(v_expression,v_position+1);
> v_position := INSTR(v_expression,','); --- --- Want to
> exit here if v_position = 0;
> v_operators(v_sub) := SUBSTR(v_expression,1,1);
> v_expression := SUBSTR(v_expression,v_position+1);
> END LOOP;
>
> Thanks!

There is no limit to the number of times you can use it other than those constrained by your business logic.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org