Sidebar

ORA-O6575: package or function _____ is in invalid state.

0 votes
3.3K views
asked May 20, 2015 by rich-c-2789 (16,180 points)
How to debug this Oracle error:

ORA-O6575: package or function _____ is in invalid state.

1 Answer

0 votes
Try running this query in SQLPlus to see a list of objects in an invalid state
 
SQL> SELECT object_name FROM user_objects WHERE status='INVALID';
 
If it is just the qieAddUpdateProblem procedure or they are all qie procedures try recompiling the procedure and then look at the errors.
 

SQL> alter procedure qieAddUpdateProblem compile;

SQL> show errors

 
It is possible that some other object in the database changed and the recompile solved the issue and no errors are returned with the show errors command. If errors are returned send them to Qvera support.
answered May 20, 2015 by rich-c-2789 (16,180 points)
...