GOTO statement v15
GOTO statement causes the point of execution to jump to the statement with the specified label.
The syntax of a
GOTO statement is:
label is a name assigned to an executable statement.
label must be unique in the scope of the function, procedure, or anonymous block.
To label a statement, use this syntax:
statement is the point of execution that the program jumps to.
You can label assignment statements, any SQL statement (like
CREATE), and selected procedural language statements. The procedural language statements that can be labeled are:
exit is considered a keyword and you can't use it as the name of a label.
GOTO statements can't transfer control into a conditional block or sub-block. However, they can transfer control from a conditional block or sub-block.
GOTO statements have the following restrictions:
GOTOstatement can't jump to a declaration.
GOTOstatement can't transfer control to another function, or procedure.
- Don't place a
labelat the end of a block, function, or procedure.
This example verifies that an employee record contains a name, job description, and employee hire date. If any piece of information is missing, a
GOTO statement transfers the point of execution to a statement that prints a message that the employee isn't valid.