Site icon IT Tutorial

PLS-00905 object is invalid

I got ” PLS-00905 object is invalid ”  error in Oracle database.

 

PLS-00905 object is invalid

 

Details of error are as follows.

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.


 

 

object string is invalid

This PLS-00905 error is related to the 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.

Find out what invalidated the package specification or stored subprogram, then make sure that Oracle can recompile it without errors.

 

SQL> alter procedure SCHEMA.PROCEDURE_NAME recompile;
SQL> show errors

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

Exit mobile version