|Oracle® Database PL/SQL Language Reference
11g Release 2 (11.2)
Part Number E17126-03
EXCEPTION_INIT pragma can appear only in the same declarative part as its associated exception, anywhere after the exception declaration.
The name of a previously declared user-defined exception.
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").
NO_DATA_FOUNDis a predefined exception.
In this chapter:
In other chapters: