|Oracle9i Application Developer's Guide - Advanced Queuing
Release 1 (9.0.1)
Part Number A88890-02
Administrative Interface, 10 of 36
To refer to the table of all basic operations having to do with the Administrative Interface see:
Drops an existing queue.
DROP_QUEUE is not allowed unless
STOP_QUEUE has been called to disable the queue for both enqueuing and dequeuing. All the queue data is deleted as part of the drop operation.
When a queue, queue table, or subscriber is created, modified, or dropped, and if GLOBAL_TOPIC_ENABLED = TRUE, a corresponding LDAP entry is also created.
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Use the following syntax references for each programmatic environment:
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Examples are provided in the following programmatic environments:
/* Stop the queue preparatory to dropping it (a queue may be dropped only after it has been succesfully stopped for enqueing and dequeing): */ EXECUTE dbms_aqadm.stop_queue ( Queue_name => 'aq.Msg_queue'); /* Drop queue: */ EXECUTE dbms_aqadm.drop_queue ( Queue_name => 'aq.Msg_queue');
EXECUTE DBMS_AQADM.DROP_QUEUE( queue_name => 'Nonpersistent_singleconsumerq1'); EXECUTE DBMS_AQADM.DROP_QUEUE( queue_name => 'Nonpersistent_multiconsumerq1');