WHENEVER SQLERROR
WHENEVER SQLERROR { {EXIT [SUCCESS | FAILURE |n
|variable
|:BindVariable
] [COMMIT | ROLLBACK]} | {CONTINUE [COMMIT | ROLLBACK | NONE]}
Specifies action to be taken by SQL*Plus if an error is generated by SQL or a PL/SQL block.
Directs SQL*Plus to exit as soon as a SQL or PL/SQL error is detected.
Exits normally with a return code indicating success. This is the default.
Exits with a return code indicating failure.
A specific numeric return code to be returned.
A user-defined or system variable whose value will be used as the return code.
A variable created in SQL*Plus with the VARIABLE command and then referenced in PL/SQL.
Turns off the EXIT option.
Directs SQL*Plus to execute a COMMIT before exiting or continuing after a SQL or PL/SQL error.
Directs SQL*Plus to execute a ROLLBACK before exiting or continuing after a SQL or PL/SQL error.
Directs SQL*Plus to take no action after a SQL or PL/SQL error.