Exception Handler

An exception handler processes a raised exception (run-time error or warning condition). The exception can be either predefined or user-defined. The run-time system raises predefined exceptions automatically, but you must raise user-defined exceptions explicitly with either a RAISE statement or the procedure DBMS_STANDARD.RAISE_APPLICATION_ERROR. The latter lets you associate an error message with the user-defined exception.

Topics:

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

exception_handler ::=

Description of the illustration exception_handler.gif

See statement ::=.

Semantics

exception_name

The name of either a predefined exception (see Table 11-2) or a user-defined exception (see "Exception").

If a specified exception is raised, the associated statement runs.

OTHERS

Specifies all exceptions not explicitly named in the exception-handling part of the block. WHEN OTHERS is optional. If used, it must be the last exception handler in the exception-handling part of the block.

If an exception that is not explicitly named is raised, the associated statement runs.

Examples

• Example 2-24, "Block with Multiple and Duplicate Labels"

• Example 5-35, "TRIM Method"

• Example 5-38, "Collection Exceptions"

• Example 6-40, "ROLLBACK Statement"

• Example 7-13, "Validation Checks Guarding Against SQL Injection"

• Example 8-1, "Declaring, Defining, and Invoking a Simple PL/SQL Procedure"

• Example 10-6, "Creating emp_admin Package"

• Example 11-3, "Anonymous Block with Exception Handlers"

• Example 11-6, "Scope of Exceptions"

• Example 11-12, "Reraising an Exception"

• Example 12-10, "Rollbacks with FORALL Statement"

• Example 12-11, "FORALL Statement and SQL%BULK_EXCEPTIONS"

Related Topics

In this chapter:

• "Block"

• "EXCEPTION_INIT Pragma"

• "Exception"

• "RAISE Statement"

• "SQLCODE Function"

• "SQLERRM Function"

In other chapters:

• "Exception Handlers"