We would like to manage AQs across numerous databases from a central "parent" via DBLINKS.

Specifically we want to programmatically stop and restart dequeuing where the only knowns are the database and schema names. Via DBLINKs the program already determines and persists the available queues and their starting states> What we also need it to do is to either disable (as required) or re-enable back to the original start points. The ability to perform the latter operations over DBLINKs is what I need some assistance with.

What we don't want to do (if possible) is to build and maintain stored procedures/functions all over the place to provide functionality that should be "generalizable" on a central - "parental" - node.

So, we've established links to the "child" databases using a common username, granting that user the privileges required to execute the DBMS_AQADM.STOP_QUEUE and DBMS_AQADM.START_QUEUE commands. I've able to successfully issue selects, etc. from the parent to the children via the links.

Where I'm stumped is in determining the correct syntax for parental performance of DBMS_AQADM operations on the children.

ORA-24000: invalid value SCHEMA.QNAME@target.system.cornell.edu, QUEUE_NAME should be of the form [SCHEMA.]NAME
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4792
ORA-06512: at "SYS.DBMS_AQADM", line 217
ORA-06512: at "SOAAQMGMT.SET_AQ_DQING_STATE", line 16
ORA-06512: at line 13

I've tried many, many, MANY combinations of the pertinent values and am stuck.

Please advise as to what the correct syntax for this type of operation over a DBLINK should be.