ora-04068,Ora-04063

[DBA_YNR]

Hi,

We have upgraded the oracle to 9.2.0.4.
There are some daily jobs. For first few days after the upgardation it was working fine but on one day we are facing below error...
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "TMOADMIN.EDIT_SPT_EVNT_RULE" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 161
We recompile the libraries and it was working fine.
can any body let me know why this error occure and what could we do so that this error should not come in future.

Thanks & regards,

[ddrozdov]

Say you have an active session that is using package x
the package x is instantiated in the SGA and in PGA for this session.

Say another session runs create or replace on x

Next time the active session is calling anythying from x it gets this exception.
ORA-04068: existing state of packages has been discarded

Oracle says: something changed in this package, Maybe the global variable whose value you are storing in pga does not exist anymore.

Did you also bounce the DB when you recompiled the package?