ORA-04068: Existing state of packages has been discarded
Try to recompile the package (body) to see if it compiles. If it does, try to re-execute what you were doing, else fix the code.
Welcome to our forum for Oracle error: ORA-04068 Add your own message
But it's compiling,While executing the error is coming..Can u help me/.....
EXAMPLE IS LIKE THIS;
SQL> CREATE OR REPLACE PROCEDURE sendmessage(msg VARCHAR2) AS
2 status_id NUMBER;
3 BEGIN
4 DBMS_PIPE.PACK_MESSAGE(LENGTH(msg));
5 DBMS_PIPE.PACK_MESSAGE(msg);
6 status_id := DBMS_PIPE.SEND_MESSAGE('send_message');
7 IF status_id != 0
8 THEN
9 raise_application_error(-20099, 'send error');
10 END IF;
11 END sendmessage;
12 /
Procedure created.
SQL> exec sendmessage('hello');
BEGIN sendmessage('hello'); END;
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SCOTT.DBMS_PIPE" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SCOTT.SENDMESSAGE", line 4
ORA-06512: at line 1
Or did you run the catalog scripts connected as the SCOTT user?
Check the all_synonyms and all_objects data dictionary views to see where DBMS_PIPE points to
PLEASE if any one of you can HElp me....I would be grateful to you...alll
"I am having error free packages but whenever i run my concern java file i am getting the error as ora-04068 but at the same time i am getting the valid state of that package at backend "
I am facing the same problem. Did you manage to resolve your issue?
Maybe it is a privilege problem?
You might want to enable tracing from within your java application:
alter session set sql_trace=true
Maybe to (raw) trace file will shed some light on your problem.
I am getting this error when i am creating materialized view. 1 month before i upgraded my oracle from 9.2.0.1.0 to 9.2.0.8.0. But after that it was working fine. Two days before i dropped the materialized view and i tried to create again. At that time i got this error.
sQL> CREATE MATERIALIZED VIEW CBS_MERCHANT_MVIEW
BUILD IMMEDIATE
REFRESH FAST
START WITH SYSDATE
NEXT sysdate + 1/(60*24)
ON DEMAND
AS
SELECT * FROM TBA_FCET_FOREX_INTERFACE_TBL@trgFIN; 2 3 4 5 6 7 8
SELECT * FROM TBA_FCET_FOREX_INTERFACE_TBL@trgFIN
*
ERROR at line 8:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_LOGSTDBY" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_JOB", line 122
ORA-06512: at "SYS.DBMS_IREFRESH", line 186
ORA-06512: at "SYS.DBMS_IREFRESH", line 369
ORA-06512: at "SYS.DBMS_REFRESH", line 88
ORA-06512: at "SYS.DBMS_REFRESH", line 62
ORA-06512: at "SYS.DBMS_ISNAPSHOT", line 76
ORA-01403: no data found
ORA-06512: at line 1
wat could be the reason for this error. Can someone help me out...
Logon to your database using "/ as sysdba" and execute
@?/rdbms/admin/utlrp
After that you might want to check for invalid objects in the SYS schema:
select object_name, object_type from dba_objects where owner='SYS' and status='INVALID'
Also make sure the patch was successful, check v$registry for that purpose and make sure all is ok and has the correct version.
I created materialized view in Database B. The master table is in Database A.
If i shutdown the database B and bring it up again, the next refresh time in dba_jobs table
in database A is coming as 01-jan-00. It is not getting refreshed automatically. The
job_queue_process is 10. wat could be the reason, for the refresh failure. Can someone help me out..
thanks in advance...
Check the status of the job, and set it to unbroken using:
exec dbms_job.broken(<jobid>, false);
I want to know why the job is getting broken after i shutdown the database....
thanks for ur reply...
The log files for the job queue processes are in the background dump destination of the database.
In order to find this, login as a user with dba privileges and execute command:
SQL> show parameter background_dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /opt/oracle/admin/MYDB/bdum p
Navigate to this directory and look for files of the format:
mydb_j000_<spid>.trc
Have a look at the files, they will tell you what is wrong.
@abishek: Well, you are pulling out the rug from under them by changing the package while they are connected, so this warning (!) is expected. See http://oraclequirks.blogspot.com/2007/03/ora-04061-existing-state-of-package-has.html for details of what's going on there and why. Quoting Flavio from there:
"Changing a tiny bit in a package specification can cause extensive damage to all the clients connected, directly or indirectly."
"You must be aware of the consequences of upgrading the package in a
running system otherwise you may run the risk of disrupting the
operations of dozen of users."
SELECT INV_QOH, INV_SIZE, COLOR
FROM INVENTORY
WHERE INV_QOH > 0, AND INV_SIZE IN ('M', 'L')
AND COLOR IN ("ROYAL", "BRIGHT PINK", "SPRUCE");
Strings need to be between single quotes, not double quotes
SELECT INV_QOH, INV_SIZE, COLOR
FROM INVENTORY
WHERE INV_QOH > 0, AND INV_SIZE IN ('M', 'L')
AND COLOR IN ('ROYAL', 'BRIGHT PINK', 'SPRUCE');
when I submit it this way the only thing that shows up is the headers, does it have anything to do with all the statements being true?
Your query did not return any records.
Best thing is to brake this apart:
select count(*) from inventory;
select count(*) from inventory where inv_qoh>0;
select count(*) from inventory where inv_qoh>0 and inv_size in ('M', 'L');
select count(*) from inventory where inv_qoh>0 and inv_size in ('M', 'L') AND COLOR IN ('ROYAL', 'BRIGHT PINK', 'SPRUCE');
when i granted the create job in oracle9i ,eg: grant create job to schema name .It shows error missing or invalid privileges. What is the correct command to granted the create job in oracle9i ?
Normally you can just do:
grant create job to otheruser;
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.