Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2) Part Number E17126-08 |
|
|
PDF · Mobi · ePub |
In an exception handler, the SQLCODE
function returns the numeric code of the exception being handled. (Outside an exception handler, SQLCODE
returns 0
.)
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 EXCEPTION_INIT
pragma.
A SQL statement cannot invoke SQLCODE
.
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 WNPS
and RNPS
.
See Also:
Oracle Database Error Messages for a list of Oracle Database error messages and information about them, including their numbers