Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page