Create a Non-Persistent Queue

Figure 9-7 Use Case Diagram: Create a Non-Persistent Queue

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

Create a non-persistent RAW queue.

Usage Notes

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 cannot dequeue from a non-persistent queue. The only way to retrieve a message from a non-persistent queue is by using the OCI notification mechanism (see Register for Notification).

You cannot invoke the listen call on a non-persistent queue (see Listen to One (Many) Queue(s)).

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, CREATE_NP_QUEUE procedure

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

• Java (JDBC): There is no applicable syntax reference for this use case

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): Create a Non-Persistent Queue

/* Create a non-persistent 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 non-persistent 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); 

Java (JDBC): Create a Non-persistent Queue

Feature not available through Java API.