Add support for the GOTO statement in stored procedures, for Oracle compatibility.
Note, Oracle's implementation has a number of restrictions.
A GOTO statement cannot transfer control:
- into an IF statement, CASE statement, LOOP statement, or sub-block.
- from one IF statement clause to another, or from one CASE statement WHEN clause to another.
- out of a subprogram.
- into an exception handler.
- from an exception handler back into the current block (but it can transfer control from an exception handler into an enclosing block).
Under terms of this task will also labels to be used with non-block and non-loop statements:
Currently the above definition returns a syntax error:
Labels with non-block/loop statements are needed, for example, to leave a loop which is inside a loop, which is inside a loop.