Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-04068: existing state of packages has been discarded

ORA-04068: existing state of packages has been discarded

From: raghu <raghu_vnin_at_yahoo.com>
Date: 8 Jul 2006 17:48:32 -0700
Message-ID: <1152406112.253713.161920@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.
Received on Sat Jul 08 2006 - 19:48:32 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US