recompiling the invalidated dependent packages

From: NKrishnan <krishnannatesan_at_att.net>
Date: 16 Jun 2004 11:30:14 -0700
Message-ID: <e95aa208.0406161030.27f85615@posting.google.com>

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 Received on Wed Jun 16 2004 - 13:30:14 CDT