WHENEVER SQLERROR

WHENEVER SQLERROR {CONTINUE [COMMIT|ROLLBACK|NONE]}

Performs the specified action if a SQL command or PL/SQL block generates an error.

Terms | Usage | Top

Refer to the following list for a description of each term or clause:

CONTINUE

Turns off the EXIT option. EXIT is not supported in this release of iSQL*Plus.

COMMIT

Directs SQL*Plus to execute a COMMIT before exiting or continuing and save pending changes to the database.

ROLLBACK

Directs SQL*Plus to execute a ROLLBACK before exiting or continuing and abandon pending changes to the database.

NONE

Directs SQL*Plus to take no action before continuing.

Usage | Terms | Top

The WHENEVER SQLERROR command is triggered by SQL command or PL/SQL block errors, and not by SQL*Plus command errors.