Query user_errors table : user_errors « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. user_errors

SQL>
SQL> COLUMN    name FORMAT a22
SQL> COLUMN    line FORMAT 9999
SQL> COLUMN    text FORMAT a30 word_wrapped
SQL> SELECT    name, type, line, text
  2  FROM      user_errors
  3  where     rownum < 2
  4  ORDER BY  name, type, sequence;

NAME                   TYPE          LINE TEXT
---------------------- ------------ ----- ------------------------------
WAIT                   PROCEDURE        3 PL/SQL: Statement ignored

SQL>
SQL>