Search 800 + Posts

Sep 17, 2009

ORA-04061: existing state of has been invalidated

Recently one of our technical analyst came across error

ORA-04061: existing state of has been invalidated ORA-04061: existing state of package body "XXEORA.XXEORA_OM_DETAILS_PKG" has been invalidated

But when we look into our database package "XXEORA.XXEORA_OM_DETAILS_PKG" everything looks normal and
Select status from all_objects
where object_name = 'XXEORA.XXEORA_OM_DETAILS_PKG'

was returning Valid status.

NOTE - This database package was called from Oracle workflow.

I did quick research and found that , in such scenarios , it was advisable to
1. bouncing middle tier services
2.recompile the package
3.restarting the notification mailer resolve this issue

1 comment:

  1. I have seen these cases, where the custom package which is calling some publi API's . Becasue of any upgrade/patch , the public API might modified which is causing this issue. Re-compiling the custom package solved the issue.