I have a production problem with package compilation.
I am trying to install a software that has plenty of stored procedures and using java and XML stuff too internally.
I am using Oracle 188.8.131.52.0 on Solaris 8.
I am getting the following error
Re-compiled VIEW PV10 because it had invalid status
Re-compiled VIEW PV11 because it had invalid status
Re-compiled VIEW PV9 because it had invalid status
Re-compiled 4 invalid PL/SQL objects
ORA-99999: Invalid PL/SQL Object found - MYPRDCDT type PACKAGE BODY status INVALID
ERROR at line 1:
ORA-20999: Found 1 PL/SQL objects which are invalid - please investigate
ORA-06512: at line 55
I have been told that after running initxml.sql this prob will be solved. I executed the same script successfully but still having the problem.
I will appreciate it, if you pls give me some input.