---

EXCEPTION_INIT Pragma

The EXCEPTION_INIT pragma associates a user-defined exception name with an error code.

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

Topics:

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

exception_init_pragma ::=

Description of the illustration exception_init_pragma.gif

Semantics

exception_name

The name of a previously declared user-defined exception.

error_code

The error code to be associated with the user-defined exception. This number can be either 100 (the numeric code for "no data found" that "SQLCODE Function" returns) or any negative integer greater than -10000000 except -1403 (another numeric code for "no data found").

Note:

NO_DATA_FOUND is a predefined exception.

Examples

• Example 11-5, "Naming Internally Defined Exception"

• Example 11-12, "Raising User-Defined Exception with RAISE_APPLICATION_ERROR"

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

Related Topics

In this chapter:

• "Exception Name Declaration"

• "Exception Handler"

• "SQLCODE Function"

• "SQLERRM Function"

In other chapters:

• "Internally Defined Exceptions"

• "RAISE_APPLICATION_ERROR Procedure"