ORA-04068 & ORA-04065 using dbms_output
I am having a problem with my upgraded 10g db. I used the pre-install script before upgrading my database and made the appropriate changes. Unfortunately it did not give me the correct min value for java_pool, therefore the upgrade, using dbua failed. I was then forced to run the upgrade script for the remainder of the install. All of the needed components were upgraded but, I was forced to uninstall javavm. Oracle support said that this should not effect the basic db functionality.
When attempting to run a pl/sql package from a ksh script; I am continually getting the following error defining the failure of the package to complete:
BEGIN ins_voice_traffic.load_voice_maint(15070,'SAUR80'); END;
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "PUBLIC.DBMS_OUTPUT"
ORA-06508: PL/SQL: could not find program unit being called:
ORA-06512: at "DWSTAGE.INS_VOICE_TRAFFIC", line 96
ORA-06512: at line 1
LINE 96 looks as follows:
dbms_output.put_line(l_gateway_id||' STAGE SUCCESSFUL '||l_load_id);
Originally I was using global parameters in this dbms_output call and figured that was the issue. I then changed the variables in the call to the declared local variables that you see above, after setting each equal to the corresponding global value.
I kicked off the script and it worked a few times without problems but eventually, I received the errors above again. I found some good documentation for this error outside of metalink but nothing has completely resolved the issue.
Could this have anything to do with the fact that JavaVM was unistalled from the database? After several nights of analysis Oracle support seems to think that installing this may be the answer. I think they may, once agian, spinning my wheels.
Any help would be appreciated.