WHENEVER OSERROR

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

Performs the specified action if an operating system error occurs (such as a file I/O 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

If you do not enter the WHENEVER OSERROR command, the default behavior of SQL*Plus is to continue and take no action when an operating system error occurs.

If you do not enter the WHENEVER SQLERROR command, the default behavior of SQL*Plus is to continue and take no action when a SQL error occurs.