O'Reilly logo

Oracle Built-in Packages by John Beresniewicz, Charles Dye, Steven Feuerstein

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

DBMS_AQ: Interfacing to Oracle AQ (Oracle8 only)

The DBMS_AQ package provides an interface to the operational tasks of Oracle AQ as performed by the programs listed in Table 5.1. To use these programs, you must have been granted the new role AQ_USER_ROLE.

Table 5-1. DBMS_AQ Programs

Name

Description

SQL?

ENQUEUE

Adds a message to the specified queue.

No

DEQUEUE

Retrieves a message from the specified queue.

No

The following sections describe how to call these programs.

Enqueuing Messages

The ENQUEUE procedure allows you to add a message to a specified queue.

The DBMS_AQ. ENQUEUE procedure

Use the ENQUEUE procedure to add a message to a particular queue. Here’s the header for the procedure:

PROCEDURE DBMS_AQ.ENQUEUE 
   (queue_name IN VARCHAR2,
    enqueue_options IN DBMS_AQ.ENQUEUE_OPTIONS_T,
    message_properties IN DBMS_AQ.MESSAGE_PROPERTIES_T,
    payload IN <type_name>,
    msgid OUT RAW);

Parameters are summarized in the following table.

Name

Description

queue_name

Specifies the name of the queue to which this message should be enqueued. The queue cannot be an exception queue and must have been previously defined by a call to DBMS_AQADM.CREATE_QUEUE.

enqueue_options

A record containing the enqueuing options, defined using the specified record type. See Section 5.3.7 for more details.

message_properties

A record containing the message properties, defined using the specified record type. See Section 5.3.6 for more details.

payload

The data or payload that is placed on the queue. This ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required