Oracle9i Application Developer's Guide - Advanced Queuing Release 1 (9.0.1) Part Number A88890-02 |
|
Administrative Interface, 9 of 36
Alter existing properties of a queue. Only max_retries, comment, retry_delay, and retention_time can be altered.
To view retained messages, you can either dequeue by message ID or use SQL.
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:
/* Alter queue to change retention time, saving messages for 1 day after dequeueing: */ EXECUTE dbms_aqadm.alter_queue ( queue_name => 'aq.Anothermsg_queue', retention_time => 86400);
/* Alter a queue to change retention time, saving messages for 1 day after dequeuing */ public static void example(AQSession aq_sess) throws AQException { AQQueueProperty queue_prop; AQQueue queue; /* Get the queue object */ queue = aq_sess.getQueue("AQ", "Anothermsg_queue"); /* Create a new AQQueueProperty object: */ queue_prop = new AQQueueProperty(); /* Change retention time to 1 day */ queue_prop.setRetentionTime(new Double(86400)); /* Alter the queue */ queue.alterQueue(queue_prop); }
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|