December 2002
Intermediate to advanced
928 pages
85h 29m
English
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 ...