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,