DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: loop back in loop

  1. #1
    Join Date
    Feb 2001
    Posts
    75

    Angry

    Hi,

    This will be too trivial to many.

    I want to loop back to the top of the loop. Seems PL/SQL has neither CONTINUE nor BREAK. What am I missing?




  2. #2
    Join Date
    Jan 2001
    Posts
    153
    Hi

    Why donn u look at rollback / savepoint...otherwise i couldnt think of anything immd..

    Vijay.s

  3. #3
    Join Date
    Feb 2001
    Posts
    75

    Angry Loop back to beginning of loop

    Hi Vijay,

    rollack / savepoint will do the rollback upto the savepoint. I do not want to rollback. I just do not want to execute remaining portion of loop and go back to beginning of loop.

    Is good old GOTO & Label are the only way?


  4. #4
    Join Date
    Aug 2000
    Posts
    462
    loop
    ___The_loop_code_I_always_want_to_execute;
    ___if I_want_to_execute_the_rest_of_the_code then
    ______The_rest_of_the_code;
    ___end if;
    end loop;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width