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

"Gina Lee" <glee_at_aol.com> wrote in
news:4N8i9.56696$8b1.44533_at_news01.bloor.is.net.cable.rogers.com:

> Does anyone know how to fix the following:
>
> $ sqlplus
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Wed Sep 18 20:22:03 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> Enter user-name: system
> Enter password:
> ERROR:
> ORA-04068: existing state of packages has been discarded
> ORA-04067: not executed, package body "SYSTEM.DBMS_OUTPUT" does not exist
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
>
>
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - 64bit Production
>
> SQL>
>
>
>

My initial thought is that your DB has a logon trigger and that some code being called by that trigger does not exist or is no longer valid.

HTH & YMMV HAND! Received on Thu Sep 19 2002 - 03:14:22 CEST