Name

WHENEVER SQLERROR

Synopsis

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.

EXIT

Directs SQL*Plus to exit as soon as a SQL or PL/SQL error is detected.

SUCCESS

Exits normally with a return code indicating success. This is the default.

FAILURE

Exits with a return code indicating failure.

n

A specific numeric return code to be returned.

variable

A user-defined or system variable whose value will be used as the return code.

BindVariable

A variable created in SQL*Plus with the VARIABLE command and then referenced in PL/SQL.

CONTINUE

Turns off the EXIT option.

COMMIT

Directs SQL*Plus to execute a COMMIT before exiting or continuing after a SQL or PL/SQL error.

ROLLBACK

Directs SQL*Plus to execute a ROLLBACK before exiting or continuing after a SQL or PL/SQL error.

NONE

Directs SQL*Plus to take no action after a SQL or PL/SQL error.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset