Purge/Delete AQ Messages

Manual deletion of AQ message leads to various problem error such as " A resource exception occurred while waiting for inbound messages", it's always advisable to use scripts to delete the AQ messages.


Below script deletes the messages from Queue table.

DECLARE
po dbms_aqadm.aq$_purge_options_t;
BEGIN

po.block := FALSE;

DBMS_AQADM.PURGE_QUEUE_TABLE(

queue_table => 'AIA_SALESORDERJMSQTAB',

purge_condition => NULL,

purge_options => po);

END;