recompiling the invalidated dependent packages
From: NKrishnan <krishnannatesan_at_att.net>
Date: 16 Jun 2004 11:30:14 -0700
Message-ID: <e95aa208.0406161030.27f85615_at_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.
Krishnan Received on Wed Jun 16 2004 - 20:30:14 CEST
Date: 16 Jun 2004 11:30:14 -0700
Message-ID: <e95aa208.0406161030.27f85615_at_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 - 20:30:14 CEST