For an internally defined exception, the numeric code is the number of the associated Oracle Database error. This number is negative except for the error "no data found", whose numeric code is +100.
For a user-defined exception, the numeric code is either +1 (default) or the error code associated with the exception by the
A SQL statement cannot invoke
If a function invokes
SQLCODE, and you use the
RESTRICT_REFERENCES pragma to assert the purity of the function, then you cannot specify the constraints
See Also:Oracle Database Error Messages for a list of Oracle Database error messages and information about them, including their numbers