Drop a Queue Table

Figure 9-5 Use Case Diagram: Drop a Queue Table

To refer to the table of all basic operations having to do with the Administrative Interface see: "Use Case Model: Administrative Interface -- Basic Operations"

Purpose:

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.

Usage Notes

Not applicable.

Syntax

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:

• PL/SQL (DBMS_AQADM Package): Oracle8i Supplied PL/SQL Packages Reference DBMS_AQADM, DROP_QUEUE_TABLE procedure.

• Visual Basic (OO4O): There is no applicable syntax reference for this use case

• Java (JDBC): Oracle8i Supplied Java Packages Reference oracle.AQ AQQueueTable.drop

Examples

See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Examples are provided in the following programmatic environments.

• PL/SQL (DBMS_AQADM Package): Drop a Queue Table

• VB (OO4O): Example not provided.

• Java (JDBC): Drop a Queue Table

PL/SQL (DBMS_AQADM Package): Drop a Queue Table

/* 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'); 

Caution: You may need to set up or drop data structures for certain examples to work:

/* 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);

Java (JDBC): Drop a Queue Table

/* 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"); 
}