Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Parameters

WHENEVER OSERROR

Use this form of the command to tell SQL*Plus what to do in the event of an operating system error.

WHENEVER SQLERROR

Use this form of the command to tell SQL*Plus what to do when an error is returned from a SQL statement or a PL/SQL block.

EXIT SUCCESS

Exit with a success status.

EXIT FAILURE

Exit with a failure status.

EXIT value

Exit and return the value specified as the status. The value may be a literal or a user variable.

EXIT :bind_variable

Exit and return the value of the specified bind variable as the status.

CONTINUE

Do not exit if an error occurs. This is the default behavior when you first start SQL*Plus.

COMMIT

May be used in conjunction with both EXIT and CONTINUE. It causes SQL*Plus to COMMIT the current transaction when an error occurs. This is the default behavior when you use the EXIT keyword.

ROLLBACK

May be used in conjunction with EXIT and CONTINUE and causes SQL*Plus to roll back the current transaction when an error occurs.

NONE

May be used only in conjunction with CONTINUE and causes SQL*Plus to neither commit nor roll back when an error occurs. This is the default behavior when you use the CONTINUE keyword.

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,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page