Re: Problems using LOOP..END LOOP, label and LEAVE
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.
Subject
Views
Written By
Posted
5271
June 29, 2005 06:25AM
2369
June 29, 2005 07:26AM
Re: Problems using LOOP..END LOOP, label and LEAVE
2456
June 30, 2005 12:38AM
2388
June 30, 2005 04:57AM
2267
June 30, 2005 05:41AM
2314
July 01, 2005 04:17AM
2289
July 01, 2005 05:23AM
2263
July 01, 2005 06:04AM
2861
July 01, 2005 06:29AM
2329
July 01, 2005 07:11AM
4551
July 01, 2005 04:39PM
2412
July 17, 2005 01:24AM
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.