Re: ORA-04068: existing state of packages has been discarded

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 9 Jul 2006 06:42:05 -0400
Message-ID: <EOSdnakUq4viQC3ZnZ2dnUVZ_qqdnZ2d@comcast.com>

"raghu" <raghu_vnin_at_yahoo.com> wrote in message news:1152406112.253713.161920_at_m73g2000cwd.googlegroups.com...
: Hi,
:
: I added a new stored procedure to a package and compiled it. If the
: stored proc is executed, it runs perfectly. However if it is executed
: from a script (which also has calls to other procedures in the
: package), I get the following weird error:
: "ORA-04068: existing state of packages has been discarded".
:
: Recompiling and executing it multiple times did not help. Database is
: Oracle 9i and this error appears both in SQLPlus and in Toad.
:
: Thanks.
:

your package(s) and session state have been invalidated because a dependency changed

check your code to see modifications you are making to database objects (of any sort) that you packages are dependent on

(for more info look into the Oracle9i Application Developer's Guide - Fundamentals at http://tahiti.oracle.com)

++ mcs Received on Sun Jul 09 2006 - 05:42:05 CDT