|Oracle® Database PL/SQL Language Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
For an exception that the database raises, 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 (the default) or the Oracle Database error number associated with the exception by the
A SQL statement cannot invoke
SQLCODE. To use the value of
SQLCODE in a SQL statement, assign it to a local variable first.
If a function invokes
SQLCODE, and you use the
RESTRICT_REFERENCES pragma to assert its purity, 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