EXIT statement breaks out of a loop. The
EXIT statement has two forms: the unconditional
EXIT and the conditional
WHEN. With either form, you can name the loop to be exited. For more information, see "Controlling Loop Iterations: LOOP and EXIT Statements".
An expression that returns the Boolean value
NULL. It is evaluated with each iteration of the loop. If the expression returns
TRUE, the current loop (or the loop labeled by
label_name) is exited immediately. For the syntax of
boolean_expression, see "Expression Definition".
EXIT statement (that is, one without a
WHEN clause) exits the current loop immediately. Execution resumes with the statement following the loop.
Identifies the loop exit from: either the current loop, or any enclosing labeled loop.
EXIT statement can be used only inside a loop; you cannot exit from a block directly. PL/SQL lets you code an infinite loop. For example, the following loop will never terminate normally so you must use an
EXIT statement to exit the loop.
WHILE TRUE LOOP ... END LOOP;
If you use an
EXIT statement to exit a cursor
FOR loop prematurely, the cursor is closed automatically. The cursor is also closed automatically if an exception is raised inside the loop.
For examples, see the following: