Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Package being invalidated at LOGIN - SQLPLUS

Package being invalidated at LOGIN - SQLPLUS

From: Cecil D'Souza <cecildsouza_at_comcast.net>
Date: Sun, 12 May 2002 22:27:52 GMT
Message-ID: <I%BD8.151160$q8.15660861@bin3.nnrp.aus1.giganews.com>


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:

ORA-04067 not executed, string does not exist Cause: Attempt to execute a non-existent stored procedure. Action: Make sure that a correct name is given.

ORA-04068 existing state of packagesstringstringstring has been discarded Cause: An error occurred when attempting to execute a stored procedure. Action: Refer to the accompanying messages and fix the error mentioned. Try the procedure again after proper reinitialization of any application's state.

IT DOES NOT SAY HOW TO SOLVE THE PROBLEM. I would like to know what I have to do to avoid getting this error each time I log in whether as a user or SYS or SYSTEM, the error is the same. Have I missed out on running any scripts after installation?.

Thanks for all the help

Cecil Received on Sun May 12 2002 - 17:27:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US