Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_AQADM , 6 of 31
Create a nonpersistent RAW
queue.
DBMS_AQADM.CREATE_NP_QUEUE ( queue_name IN VARCHAR2, multiple_consumers IN BOOLEAN DEFAULT FALSE, comment IN VARCHAR2 DEFAULT NULL);
Parameter | Description |
---|---|
queue_name |
Name of the nonpersistent 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. |
multiple_consumers |
Note that thi |
comment |
User-specified description of the queue. This user comment is added to the queue catalog. |
The queue may be either single-consumer or multiconsumer queue. All queue names must be unique within a schema. The queues are created in a 8.1-compatible system-created queue table (AQ$_MEM_SC
or AQ$_MEM_MC
) in the same schema as that specified by the queue name.
If the queue name does not specify a schema name, then the queue is created in the login user's schema. After a queue is created with CREATE_NP_QUEUE
, it can be enabled by calling START_QUEUE
. By default, the queue is created with both enqueue and dequeue disabled.
You cannot dequeue from a nonpersistent queue. The only way to retrieve a message from a nonpersistent queue is by using the OCI notification mechanism. You cannot invoke the listen
call on a nonpersistent queue.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|