Cannot stop Oracle Queue - Could not find program unit being called: "SYS.DBMS_ASSERT"
Posted
by Vladimir Bezugliy
on Stack Overflow
See other posts from Stack Overflow
or by Vladimir Bezugliy
Published on 2010-06-07T09:57:07Z
Indexed on
2010/06/07
11:52 UTC
Read the original article
Hit count: 411
Cannot stop and drop oracle Queue.
Following code
BEGIN
DBMS_AQADM.STOP_QUEUE (
queue_name => 'TEST_QUEUE');
DBMS_AQADM.DROP_QUEUE(
queue_name => 'TEST_QUEUE');
END;
/
produces following errors:
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "SYS.DBMS_ASSERT"
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_ASSERT"
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3365
ORA-06512: at "SYS.DBMS_AQADM", line 167
ORA-06512: at line 5
What can be the root cause of this problem?
© Stack Overflow or respective owner