Dequeuing in Oracle BRM

Although it is not recommended, but sometimes in the test environment where there is no interface to dequeue the message from advance queue, the queue is clogged and we wish to dequeue it. Here is the way to do it:


DECLARE
po_t dbms_aqadm.aq$_purge_options_t;
BEGIN
dbms_aqadm.purge_queue_table('AQ_SYNC', NULL, po_t);
END;

Execute the above from SQL client or command line.