EXCEPTION_INIT Pragma

The EXCEPTION_INIT pragma associates a user-defined exception name with an Oracle Database error number. You can intercept any Oracle Database error number and write an exception handler for it, instead of using the OTHERS handler.

Topics:

• Syntax

• Semantics

• Usage

• Examples

• Related Topics

Syntax

exception_init_pragma ::=

Semantics

error_number

A valid Oracle Database error number not already associated with a user-defined exception. For a list of Oracle Database error messages and information about them, including their numbers, see Oracle Database Error Messages.

exception_name

The name of a user-defined exception.

Usage

A EXCEPTION_INIT pragma can appear only in the same declarative part as its associated exception, anywhere after the exception declaration.

Examples

• Example 11-7, "PRAGMA EXCEPTION_INIT"

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

Related Topics

In this chapter:

• "Exception"

• "Exception Handler"

• "SQLCODE Function"

• "SQLERRM Function"

In other chapters:

• "Associating Exceptions with Numbers"