Oracle in a Nutshell

Calls

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 <payload_type>, msgid OUT RAW);

Adds the message payload to the queue queue_name, using the options specified by the enqueue_options record. The payload_type is either RAW or the name of an object TYPE. Returns the pointer to the message in msgid.

PROCEDURE DBMS_AQ.DEQUEUE (queue_name IN VARCHAR2, dequeue_options IN DBMS_AQ.DEQUEUE_OPTIONS_T, message_properties OUT DBMS_AQ.MESSAGE_PROPERTIES_T, payload OUT <payload_type>, msgid OUT RAW);

This procedure has the same parameter meanings as DBMS_AQ.ENQUEUE.

DBMS_AQ.LISTEN (agent_list IN AQ$_AGENT_LIST_T, wait IN BINARY_INTEGER DEFAULT DBMS_AQ.FOREVER, agent OUT SYS.AQ$_AGENT);

Listens on one or more queues on behalf of a list of agents. New with Oracle8i.

DBMS_AQ.REGISTER (reg_list IN SYS.AQ$_REG_INFO_LIST, count IN NUMBER);

Registers an email address, PL/SQL procedure, or URL for message notification. New with Oracle9i.

DBMS_AQ.UNREGISTER (reg_list IN SYS.AQ$_REG_INFO_LIST, count IN NUMBER);

Unregisters a message notification destination. New with Oracle9i.

DBMS_AQ.POST (post_list IN SYS.AQ$_POST_INFO_LIST, count IN NUMBER);

Posts to a list of anonymous subscriptions for all clients who are registered for subscriptions. New with Oracle9i.

DBMS_AQ.BIND_AGENT (agent IN SYS.AQ$_AGENT, certificate IN VARCHAR2 DEFAULT NULL);

Creates an entry for the AQ agent in the LDAP ...