Question: I am getting the
PLS-00905 error:
SQL> exec testappt('payhr');
begin testappt('payhr'); end;
ORA-06550: line 1,
column 7:
PLS-00905: object TEST.TESTAPPT is invalid
Answer: The oerr utility shows
this for the PLS-00905 error:
oerr PLS-00905
PLS-00905: object string
is invalid
Cause: An invalid
package specification or stored subprogram was referenced. A
package specification or stored subprogram is invalid if its
source code or any database object it references has been
DROPped, REPLACEd, or ALTERed since it was last compiled.
Action: Find out what invalidated the
package specification or stored subprogram, then make sure
that Oracle can recompile it without errors.
Follow these instruction to recompile it
re-compiling invalid PL/SQL objects.
SQL> alter procedure test.testappt recompile;
SQL> show errors