MySQL Forums
Forum List  »  Stored Procedures

Re: Problems using LOOP..END LOOP, label and LEAVE
Posted by: Roland Bouman
Date: June 30, 2005 12:38AM

I tried that too (before my initial post on this problem). I used an identifier like "csr1_loop" (without the quotes, as in csr1_loop: LOOP etc.). See the related post on the Cursors forum ("dependent cursors")

By the way, does anyone no wheter LEAVE; or ITERATE; can stand by themselves? Or must they be postfixed by a label? At first i did not use labels at all, but this would not compile, so i was led to believe that the loop must be labeled, but then that did not comile too, and this is when i staqrte dposting the problem....

Best regards!

Edited 1 time(s). Last edit at 06/30/2005 12:40AM by Roland Bouman.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.