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;