PL/SQL (MOSC)

MOSC Banner

ORA-01422 ORA-06512 executing dbms_aqadm.add_subscriber

edited Mar 26, 2012 6:31AM in PL/SQL (MOSC) 6 commentsAnswered
This code works on one of our other Oracle databases (version 10.2.0.4), but for one of our databases it returns the errors below

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center