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

From: Jeff Kish <jeff.kish_at_ait-mmii.com>
Date: Mon, 09 Oct 2000 11:47:07 -0400
Message-ID: <20q3uscdon04ansl5s5tfdns2kp6ubkov2@4ax.com>

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 - 10:47:07 CDT