Monday, May 02, 2011

ORA-06575 Package or function is in an invalid state in Oracle Stored procedure

Normally this "ORA-06575 Package or function is in an invalid state" error come when the stored procedure in invalid state.To make the stored procedure to valid state we need to recompile the particular stored procedure once again.

To recompile the oracle procedure run this,

SQL>  alter procedure Procedure_Name compile;
SQL>  show errors

This will give if any error in stored procedure you have created, else if will compile properly.

At any rate, running the following query,

SQL> SELECT object_name FROM user_objects WHERE status='INVALID';

will give you the list of stored procedures in invalid state. From this one can check the stored procedure current state.

Bookmark and Share


Post a Comment

Tech World

Label Cloud

Must Buy

  © Blogger templates by updated with tips

Back to TOP