In an exception handler, the
SQLCODE function returns the numeric code of the exception being handled. (Outside an exception handler,
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
Example 11-23, "Displaying SQLCODE and SQLERRM Values"
In this chapter:
In other chapters:
Oracle Database Error Messages Reference for a list of Oracle Database error messages and information about them, including their numbers