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
Any valid Oracle Database error number. These are the same error numbers (always negative) returned by the function
A user-defined exception declared within the current scope.
Be sure to assign only one exception name to an error number.
Signifies that the statement is a pragma (compiler directive). Pragmas are processed at compile time, not at run time. They pass information to the compiler.
EXCEPTION_INIT pragma can appear only in the same declarative part as its associated exception, anywhere after the exception declaration.