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:
Please refer following resources for more information:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_1052.htm
and
http://www.techonthenet.com/oracle/sys_tables/index.php
and
http://www.techonthenet.com/oracle/sys_tables/index.php
No comments:
Post a Comment