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

From: Carl Moran <carl.moran_at_sysview.co.uk>
Date: 2000/06/16
Message-ID: <NJk25.2788$fb5.53949@news2-win.server.ntlworld.com>#1/1

I think you would only get that message if your package did not compile and you tried to run it. To be honest that is just a guess, cause I usually fix it by recompiling the package and making sure there is no errors.

EL <el_at_el.com> wrote in message
news:9d10kss62fpvd2jsgne1sh7h349mcgkopa_at_4ax.com...
> I work on an order entry system that is up 24x7 running Oracle version
> 8.0.5. I want to compile a fix to a procedure contained in a package
> body. I only will be recompiling the package body. Since the package
> body has no dependent objects, I should not invalidate any stored
> procedures that call this procedure in my package.
>
> However, should I worry about causing an "ORA-04068: existing state of
> packages has been discarded" error? What causes this error and when
> does it occur?
Received on Fri Jun 16 2000 - 00:00:00 CDT