ORA-24033: no recipients for message, shortly after subscriber added and tested. (Doc ID 2929153.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

After adding subscriber.

declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_DEFERRED';
lagent := sys.aq$_agent('WF_DEFERRED',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/

The following works until it fails.

SQL> declare
2 nid number;
3 BEGIN
4 FOR i IN 1..2
5 loop
6 DBMS_OUTPUT.PUT_LINE(wf_notification.send('<SCHEMA>','WFTESTS','PLSQL_MSG'));
7 end loop;
8 commit;
9 END;
10 /
PL/SQL procedure successfully completed.

SQL> declare
2 nid number;
3 BEGIN
4 FOR i IN 1..2
5 loop
6 DBMS_OUTPUT.PUT_LINE(wf_notification.send('<SCHEMA>','WFTESTS','PLSQL_MSG'));
7 end loop;
8 commit;
9 END;
10 /
declare
*
ERROR at line 1:
ORA-24033: no recipients for message
ORA-06512: at "<SCHEMA>.WF_NOTIFICATION", line 4379
ORA-06512: at "<SCHEMA>.WF_NOTIFICATION", line 4258
ORA-06512: at "<SCHEMA>.WF_NOTIFICATION", line 6694
ORA-06512: at "<SCHEMA>.WF_EVENT", line 1197
ORA-06512: at "<SCHEMA>.WF_EVENT", line 3038
ORA-06512: at "<SCHEMA>.WF_EVENT", line 2250
ORA-06512: at "<SCHEMA>.WF_EVENT", line 821
ORA-06512: at "<SCHEMA>.WF_EVENT", line 2591
ORA-06512: at "<SCHEMA>.WF_EVENT", line 2317
ORA-06512: at "<SCHEMA>.WF_EVENT_QH", line 311
ORA-06512: at "SYS.DBMS_AQ", line 185
ORA-06512: at "<SCHEMA>.WF_EVENT_QH", line 291
ORA-06512: at "<SCHEMA>.WF_AGT_DYN_FUNCS", line 22
ORA-06512: at "<SCHEMA>.WF_EVENT", line 2297
ORA-06512: at "<SCHEMA>.WF_EVENT", line 2585
ORA-06512: at "<SCHEMA>.WF_EVENT", line 606
ORA-06512: at "<SCHEMA>.WF_EVENT", line 2144
ORA-06512: at "<SCHEMA>.WF_EVENT", line 3024
ORA-06512: at "<SCHEMA>.WF_EVENT", line 1190
ORA-06512: at "<SCHEMA>.WF_NOTIFICATION", line 6626
ORA-06512: at "<SCHEMA>.WF_NOTIFICATION", line 4171
ORA-06512: at "<SCHEMA>.WF_NOTIFICATION", line 4331
ORA-06512: at line 6

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.