Question about loop conditions

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

    v_operators(v_sub) := SUBSTR(v_expression,1,1);     v_expression := SUBSTR(v_expression,v_position+1);   END LOOP; Thanks! Received on Thu May 29 2008 - 11:40:00 CDT