Fixed it by adding this line before I call the stored proc:
exec DBMS_DDL.ALTER_COMPILE().
Mark C. Stock wrote:
> "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 Mon Jul 10 2006 - 23:42:38 CDT
