Hi,

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 9.2.0.4.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
DECLARE
*
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.