DROP_QUEUE_TABLE v13

Use the DROP_QUEUE_TABLE procedure to delete a queue table. The signature is:

DROP_QUEUE_TABLE(
  <queue_table> IN VARCHAR2,
  <force> IN BOOLEAN default FALSE,
  <auto_commit> IN BOOLEAN default TRUE)

Parameters

queue_table

The (optionally schema-qualified) name of the queue table.

force

The force keyword determines the behavior of the DROP_QUEUE_TABLE command when dropping a table that contain entries:

• If the target table contains entries and force is FALSE, the command will fail, and the server will issue an error.

• If the target table contains entries and force is TRUE, the command will drop the table and any dependent objects.

auto_commit

auto_commit is accepted for compatibility, but is ignored.

Example

The following anonymous block drops a table named work_order_table:

BEGIN
   DBMS_AQADM.DROP_QUEUE_TABLE ('work_order_table', force => TRUE);
END;