Re: Error (-4068)--(ORA-04068: existing state of packages has been discarded

login with sufficient priveleges, preferably as owner of the package, and type:
alter package NAMEOFPACKAGE compile body;

Check for errors with:
show errors, and resolve them.

Jeff Kish wrote:

> Greetings.
>
> One of my users is getting this (I have replaced the actual package
> with the string 'NAMEOFPACKAGE', and the name of the database with
> 'THEDB'):
>
> Error (-4068)--(ORA-04068: existing state of packages has been
> discarded
> ORA-04061: existing state of package body "THEDB.NAMEOFPACKAGE" has
> been invalidated
> ORA-04065: not executed, altered or dropped package body
> "THEDB.NAMEOFPACKAGE"
> ORA-06508: PL/SQL: could not find program unit being called
>
> Can someone recommend the best way for me to trouble shoot this and
> figure out what the cause of the problem is? They tried running it
> several times, (the application that makes the call into the package)
> but the error keeps reoccurring. I thought that trying it again would
> reinitialize the situation. I am not really sure why the situation
> develops in the first place.. I mean, if noone is recompiling the
> package, why would it ever get into a weird state?
>
> Sorry for my lack of understanding in these matters!
>
> Thanks
> Jeff Kish
  Received on Mon Oct 09 2000 - 12:49:11 CDT