September 2000
Intermediate to advanced
418 pages
11h 5m
English
Content preview from Oracle SQL: the Essential Reference
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
| WHENEVER OSERROR |
WHENEVER OSERROR {EXIT {SUCCESS | FAILURE | n | var |
:bind_variable}
[COMMIT | ROLLBACK] |
CONTINUE [COMMIT | ROLLBACK | NONE]
}
|
Specifies the action to be taken by SQL*Plus if an operating system error occurs.
Keywords
EXIT
Directs SQL*Plus to exit as soon as an operating system error is detected.
COMMIT
Directs SQL*Plus to execute a COMMIT before exiting or continuing after an operating system error occurs.
CONTINUE
Turns off the EXIT option.
FAILURE
Exits with a return code indicating failure.
n
Exits and returns the specified numeric return code.
NONE
Directs SQL*Plus to take no action after an operating system error.
ROLLBACK
Directs SQL*Plus to execute a ROLLBACK before exiting or continuing after an operating system error occurs.
SUCCESS
Exits normally with a return code indicating success. This option is the default behavior.
var
A user-defined or system variable, the value of which will be used as the return code.
bind_variable
A bind variable, created in SQL*Plus with the VARIABLE command, the value of which will be used as a return code.
WARNING
Exits with a return code indicating a warning status.