|Oracle8i Application Developer's Guide - Advanced Queuing
Release 2 (8.1.6)
Part Number A76938-01
Administrative Interface, 10 of 25
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.
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');