Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Package being invalidated at LOGIN - SQLPLUS
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
![]() |
![]() |