Hi,
We are using oracle 9i and weblogic 7 sp2.
The following is the problem.
The package A depends on package B. If B is recompiled then package A
get invalidated. So far so good.
If you are already connected to the database the state of the packaes
A and B are invalid. In SQL/Plus firsttime you get the error message
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "Package B" have been
invalidated
ORA-04065: not executed, altered or dropped package body "Package B"
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "Package A", line XXXX
If I retry then it goes through.
However, from Weblogic connection pool, if I retry my program it comes
with the same error message.
Any one had similar problem?
Thanks
Krishnan