ORA-01422 ORA-06512 executing dbms_aqadm.add_subscriber
DECLARE
subscriber sys.aq$_agent;
BEGIN
subscriber := sys.aq$_agent(name => 'SUBNAME',
address => NULL,
protocol => NULL);
dbms_aqadm.remove_subscriber(queue_name => 'QNAME',
subscriber => subscriber);
dbms_aqadm.add_subscriber(queue_name => 'QTBL_NAME',
subscriber => subscriber,delivery_mode => dbms_aqadm.PERSISTENT_OR_BUFFERED);
END;
ORA-01422: exact fetch returns more than the requested number of rows
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 5758
ORA-06512: at "SYS.DBMS_AQADM", line 314
ORA-06512: at line 10
If delivery_mode => -0 is used, it works