Oracle9i Application Developer's Guide - Advanced Queuing Release 1 (9.0.1) Part Number A88890-02 |
|
Administrative Interface, 8 of 36
Create a nonpersistent queue.
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, the queue is created in the login user's schema. Once 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 can enqueue RAW and Object Type (ADT) messages into a nonpersistent queue. 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 (see Registering for Notification).
You cannot invoke the listen
call on a nonpersistent queue (see Listening to One (Many) Queue(s)).
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.
/* Create a nonpersistent single-consumer queue (Note: this is not preceded by creation of a queue table) */ EXECUTE dbms_aqadm.create_np_queue( Queue_name => 'Singleconsumersmsg_npque', Multiple_consumers => FALSE); /* Create a nonpersistent multi-consumer queue (Note: this is not preceded by creation of a queue table) */ EXECUTE dbms_aqadm.create_np_queue( Queue_name => 'Multiconsumersmsg_npque', Multiple_consumers => TRUE);
Feature not available through Java API.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|