Oracle PL/SQL: SQL Code and SQL Error Messages - Captures Oracle error codes and their associated messages.

Quick Search:

Oracle PL/SQL: SQL Code and SQL Error Messages

Jump to:

Category: >> Oracle PL/SQL >> SQL Code and SQL Error Messages

<< last

next >>

Snippet Name: SQL Code and SQL Error Messages

Description: Captures Oracle error codes and their associated messages.

Also see:
» Oracle Exception Handling
» PLSQL Errors

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 07th, 2009

SQL Code
 
NUMBER OF the most recent EXCEPTION raised BY PL/SQL. 0 IF none
 
SET serveroutput ON
 
BEGIN
  DBMS_OUTPUT.put_line(SQLCODE);
END;
/
 
 
SQL Errm
 
Error message associated WITH the specified code
 
SET serveroutput ON
 
BEGIN
  DBMS_OUTPUT.put_line(SQLERRM);
END;
/