Package in invalid status - compiles ok
902733Dec 13 2011 — edited Dec 13 2011I created a package having 2 procedures. The package compiles fine, no errors found. My "SELECT * FROM all_objects" shows the package with STATUS=INVALID.
If I try to call a procedure in the package Says "ORA-06575 Package or function is in an invalid state."
I've tried recompiling the package: "ALTER PACKAGE PKAXINT COMPILE BODY", but to no avail. And the key point being there is absolutely no compilation errors...