Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2) Part Number E25519-05 |
|
|
PDF · Mobi · ePub |
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.
LNPLS1188Topics
LNPLS1058exception_init_pragma ::=
LNPLS1060exception
Name of a previously declared user-defined exception.
LNPLS1059error_code
Error code to be associated with exception
. error_code
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.Example 11-12, "Raising User-Defined Exception with RAISE_APPLICATION_ERROR"
Example 12-13, "Handling FORALL Exceptions After FORALL Statement Completes"
LNPLS1189In this chapter:
LNPLS1190In other chapters: