Oracle Error ORA-06575: Package or function string is in an invalid state

Oracle Error Message

ORA-06575: Package or function string is in an invalid state

Reason for the Error

A SQL statement references a PL/SQL function that is in an invalid state. Oracle attempted to compile the function, but detected errors.

Solution

Check the SQL statement and the PL/SQL function for syntax errors or incorrectly assigned, or missing, privileges for a referenced object.