Hi All,
I have a package in a production database , which gets invalid in the middle of a critical job run in the database
When i check the package no errors are shown , i simply compile it and it becomes valid and restarting the job it runs fine.
Dependent objects of the package are Table,Synonym,Package.
In your experience have you faced any similar scenarios , what could be the possible reason for this situation
The developer confirmed to me that none of the dependent table of the package is being dropped and recreated , there hasn't been any code change , the job has been running for years before this issue arise.
Below is the error with which the job breaks
Exception Message:: ORA-04068: existing state of packages (PROD_DATABASE.WORLD) has been discarded
ORA-04061: existing state of package body "PROD.PACKAGE_COMMON" has been invalidated
ORA-04065: not executed, altered or dropped package body "PROD.PACKAGE_COMMON"
Db version :11.2.0.4.0
OS: Solaris 10
Thanks
Himanshu