Re: Package being invalidated at LOGIN - SQLPLUS

"Cecil D'Souza" <cecildsouza_at_comcast.net> wrote

>Hello
>
>I have installed oracle 8.1.6.2 on the SUN sparc 20. (solaris 8). I created
>a user but when I login at the SQL plus prompt, I get the following errors.
>ORA-04068: existing state of package has been discarded.
>ORA-04067: not executed, package body 'SYSTEM.DBMS_OUTPUT' does not exist
>ORA-06508: PL/SQL could not find the program unit being called
>ORA-06512: at line 1
>
>I have checked the errors on the web. The joke about Oracle's error messages
>is that they say the following:

[snip]

Sounds to me like a corrupted datadictionary. I'd suggest to let run catalog.sql, catproc.sql and utlirp.sql. That could solve your problem

kind regards
Eve Received on Sun May 12 2002 - 18:56:54 CDT