ORA-7445 on dbms_aqadm.remove_subscriber
Hi,
i am trying to remove a AQ subscriber, which gives me a "end of file communication channel".
The alert log shows me this: ORA-07445: exception encountered: core dump [kwqaChkpTxxcb()+38] [SIGSEGV] [ADDR:0xB0] [PC:0x118AE96] [Address not mapped to object] []
Anybody ever experienced this?
-- The statement
declare
procedure remove_subscriber(p_queue_name varchar2, p_subscriber varchar2)
is
aSubscriber sys.aq$_agent;
expected_error exception;
pragma exception_init(expected_error,-24035);
begin
aSubscriber := sys.aq$_agent(null,
p_subscriber,
0);
dbms_aqadm.remove_subscriber
( queue_name => 'AQ_ADMIN.'||p_queue_name
,subscriber => aSubscriber
);
end;
begin
remove_subscriber('IM_MUTATIONS_TO_MODEL','"AQ_ADMIN"."IM_CALC_DELTA_MODEL"');