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

For Any queries, please mail us at support@funoracleapps.com

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

10 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.

10 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
  5. If you need a method to monitor your teen's SMS messages, you could possibly need to look into SMS spy software. here

    ReplyDelete
  6. I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. best android app creator

    ReplyDelete
  7. Nice site. On your blogs very interest and i will tell a friends. web development firms

    ReplyDelete
  8. Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog. yabo

    ReplyDelete
  9. Excellent post. I was reviewing this blog continuously, and I am impressed! Extremely helpful information especially this page. Thank you and good luck. tudo sobre o aplicativo Appvn

    ReplyDelete
  10. This article is an appealing wealth of informative data that is interesting and well-written. I commend your hard work on this and thank you for this information. You’ve got what it takes to get attention. como baixar HappyMod apk atualizado 2020

    ReplyDelete