View oracle objects compile errors

Use Case

Check if there were any errors during oracle objects compilation (procedures, functions, packages, triggers, or package).

Solution

Oracle stores information about errors occured during objects compilation in system tables (e.g. USER_ERRORS). To view error run following sql statement:

select * from sys.user_errors where name = 'object name' and type = 'object type'

Please refer following resources for more information:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4315.htm

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_1052.htm

and

http://www.techonthenet.com/oracle/sys_tables/index.php