4.13 Errors and Messages

Table of Contents Previous Next


4 Stored Procedure Language : 4.13 Errors and Messages

Use the DBMS_OUTPUT.PUT_LINE statement to report messages.
message is any expression evaluating to a string.
The special variables SQLCODE and SQLERRM contain a numeric code and a text message, respectively, that describe the outcome of the last SQL command issued. If any other error occurs in the program such as division by zero, these variables contain information pertaining to the error.

4 Stored Procedure Language : 4.13 Errors and Messages

Table of Contents Previous Next