Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_AQADM , 5 of 31
This procedure creates a queue in the specified queue table.
DBMS_AQADM.CREATE_QUEUE ( queue_name IN VARCHAR2, queue_table IN VARCHAR2, queue_type IN BINARY_INTEGER DEFAULT NORMAL_QUEUE, max_retries IN NUMBER DEFAULT NULL, retry_delay IN NUMBER DEFAULT 0, retention_time IN NUMBER DEFAULT 0, dependency_tracking IN BOOLEAN DEFAULT FALSE, comment IN VARCHAR2 DEFAULT NULL, auto_commit IN BOOLEAN DEFAULT TRUE);
Parameter | Description |
---|---|
queue_name |
Name of the queue that is to be created. The name must be unique within a schema and must follow object name guidelines in the Oracle9i SQL Reference with regard to reserved characters. |
queue_table |
Name of the queue table that will contain the queue. |
queue_type |
Specifies whether the queue being created is an exception queue or a normal queue.
|
max_retries |
Limits the number of times a dequeue with the
The count is incremented when the application issues a rollback after executing the dequeue. The message is moved to the exception queue when it is reaches its
Note that |
retry_delay |
Delay time, in seconds, before this message is scheduled for processing again after an application rollback.
The default is 0, which means the message can be retried as soon as possible. This parameter has no effect if |
retention_time |
Number of seconds for which a message is retained in the queue table after being dequeued from the queue.
|
dependency_ tracking |
|
comment |
User-specified description of the queue. This user comment is added to the queue catalog. |
auto_commit |
Caution: This parameter has been deprecated. |
All queue names must be unique within a schema. After a queue is created with CREATE_QUEUE
, it can be enabled by calling START_QUEUE
. By default, the queue is created with both enqueue and dequeue disabled.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|