Stay at Home!! Be Safe!! Take Care!!

Thanks all my viewers for your support, I am an Oracle Ace now. For Any queries, please mail us at support@funoracleapps.com

ORA-04063: Package Body "APPS.AD_ZD_ADOP" Has Errors when running adop

4 comments
While running adop prepare,  the error is encountered on APPS.AD_ZD_ADOP . When checking further the package body is in invalid state.


Error:

When we try to compile manually, we observe below error.


SQL> alter package APPS.AD_ZD_ADOP compile body;
Warning: Package Body altered with compilation errors.
SQL> show err
Errors for PACKAGE BODY APPS.AD_ZD_ADOP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2686/3 PL/SQL: Statement ignored
2686/7 PLS-00201: identifier 'SYS.DBMS_METADATA_UTIL' must be declared


Solution:


1. Connect as sysdba and 
   grant execute on DBMS_METADATA_UTIL to apps;
2. alter package APPS.AD_ZD_ADOP compile body;

The package should be compiled normally now.

4 comments :

  1. This is such a great post, and was thinking much the same myself. Another great update. device mockups

    ReplyDelete
  2. I admire your work , regards for all the useful blog posts. iphone psd

    ReplyDelete
  3. Very educating story, saved your site for hopes to read more! ipad device template

    ReplyDelete
  4. How do I know if a Wordpress theme supports a subscribe option? android psd

    ReplyDelete