dba_errors
Name Null? Type
--------------- -------- ----------------
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
TYPE VARCHAR2(12)
SEQUENCE NOT NULL NUMBER
LINE NOT NULL NUMBER
POSITION NOT NULL NUMBER
TEXT NOT NULL VARCHAR2(4000)
Displays errors for stored database objects (procedures, views, etc.). For example, if I make a deliberate mistake while creating a procedure...
SQL> create procedure test_proc as mistake
2 /
Warning: Procedure created with compilation errors.
I can see what went wrong by querying dba_errors:
SQL> select * from dba_errors;
OWNER NAME
------------------------------ ------------------------------
TYPE SEQUENCE LINE POSITION
-------------------- ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
SYS TEST_PROC
PROCEDURE 1 1 30
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the follow
ing:
constant exception
table LONG_ double ref
char time timestamp interval date binary national character
nchar
You can also use 'show errors' from SQL*Plus to get a more nicely formatted version:
SQL> show errors
Errors for PROCEDURE TEST_PROC:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/30 PLS-00103: Encountered the symbol "end-of-file" when expecting
one of the following:
constant exception
table LONG_ double ref
char time timestamp interval date binary national character
nchar
For more useful DBA queries click here.
| 