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.

Topics

• Syntax

• Examples

• Related Topics

Syntax

sqlcode_function ::=

Description of the illustration sqlcode_function.eps

Examples

• Example 11-23, "Displaying SQLCODE and SQLERRM Values"

Related Topics

In this chapter:

• "Block"

• "EXCEPTION_INIT Pragma"

• "Exception Handler"

• "RESTRICT_REFERENCES Pragma"

• "SQLERRM Function"

In other chapters:

• "Retrieving Error Code and Error Message"