Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Any solution to "ORA-04068 existing state of packages has been discarded"?

ILya CycloneFeb 16 2012 — edited Jul 1 2013
Hi OTN,
In our production evnironment lots of business logic relay on PL/SQL procedures.
Each proc recompilation leads to numerous "ORA-04068 existing state of packages" showed to users of our ADF applicaiotns and in fact we need to restart the production server.

You know, this exception occurs only on the first query after recompilation, the second would be ok.
So if I could just reexecute ViewObject's query in case of ORA-04068, that could be a kind of solution.
Could someone advise me the way to do it, like overriding some ViewObject methods or smth.

Or there could be another global solution?

Thanks.

ADF 11.1.2.1, Oracle Server EE 11g
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2013
Added on Feb 16 2012
9 comments
11,226 views