Oracle9i Application Developer's Guide - Advanced Queuing Release 1 (9.0.1) Part Number A88890-02 |
|
Administrative Interface, 6 of 36
Drop an existing queue table. Note that you must stop and drop all the queues in a queue tables before the queue table can be dropped. You must do this explicitly unless the force
option is used in which case this done automatically.
When a queue, queue table, or subscriber is created, modified, or dropped, and if GLOBAL_TOPIC_ENABLED = TRUE, a corresponding LDAP entry is also created.
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.
/* Drop the queue table (for which all queues have been previously dropped by the user) */ EXECUTE dbms_aqadm.drop_queue_table ( queue_table => 'aq.Objmsgs_qtab'); /* Drop the queue table and force all queues to be stopped and dropped by the system */ EXECUTE dbms_aqadm.drop_queue_table ( queue_table => 'aq.Objmsgs_qtab', force => TRUE);
/* Drop a queue table - for which all queues have already been dropped by the user */ public static void example(AQSession aq_sess) throws AQException { AQQueueTable q_table; q_table = aq_sess.getQueueTable ("aq", "ObjMsgs_qtab"); /* Drop the queue table*/ q_table.drop(false); System.out.println("Successful drop"); } /* Drop the queue table (and force all queues to be stopped and dropped by the user */ public static void example(AQSession aq_sess) throws AQException { AQQueueTable q_table; q_table = aq_sess.getQueueTable ("aq", "ObjMsgs_qtab"); /* Drop the queue table (and automatically drop all queues inside it */ q_table.drop(true); System.out.println("Successful drop"); }
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|