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
2361
December 09, 2015 03:52AM
889
December 09, 2015 03:57AM
760
December 09, 2015 05:06AM
818
December 09, 2015 07:08AM
Re: stored procedure executing for infinite time
762
December 09, 2015 12:31PM
611
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.