[How To] View Compilation Errors For a Oracle Objects

[Oracle] View Compilation Errors For a Oracle Objects

Oracle stored the compilation errors for procedures, functions, packages, triggers, or package bodies in a system table called USER_ERRORS.

To view the compilation error you need to know the object type and object name. Once you know these details the following query can be executed to know the compilation errors.

sql> select * from SYS.USER_ERRORS where NAME =<object_name> and type =<object_type> ;

The following is the table structure of the USER_ERRORS table.
Vishal Lambe | Table: USER_ERRORS
The table stores the line number and position of the error along with error description and code.