ORA-01003: No Statement Parsed Running Dbms_Aqadm.Add_Subscriber (Doc ID 2231654.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

When adding a subscriber passing a RULE argument with multiple logical operands, the call may fail with ORA-01003 as noted below:

DECLARE
aSubscriber sys.aq$_agent;
BEGIN
aSubscriber := sys.aq$_agent('AGENT_TEST',
'',
0);
dbms_aqadm.add_subscriber
( queue_name => 'SCOTT.EVENT_MANAGER_QUEUE'
,subscriber => aSubscriber
,rule => 'tab.user_data.event_cd = 187 OR ((tab.user_data.event_cd,tab.user_data.sub_event_cd) in ((103,18)) AND instr(tab.user_data.filter_cd,''F1025'') != 0)');
END;
/
ORA-01003: no statement parsed
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7035
ORA-06512: at "SYS.DBMS_AQADM", line 549
ORA-06512: at line 7

 

 

Changes

 Usually the problem may happen when doing the database upgrade or when attempting to recreate the AQ Subscriber.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms