Re: stored procedure executing for infinite time
Statements need semicolon termination.
LOOP and LEAVE need label.
label: LOOP
...
if ... then
LEAVE label;
end if;
END LOOP label;
This is what the manual is for :-)
Subject
Views
Written By
Posted
3096
December 09, 2015 03:52AM
1165
December 09, 2015 03:57AM
1019
December 09, 2015 05:06AM
1052
December 09, 2015 07:08AM
Re: stored procedure executing for infinite time
976
December 09, 2015 12:31PM
808
December 09, 2015 10:55PM
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.