 |
|
DBMS_AQ package tips
Oracle Tips by Burleson Consulting |
DBMS_AQ
<< Return to the index
Related notes on DBMS_AQ:
Oracle 11g provides the following information about the DBMS_AQ package:
Description of the DBMS_AQ package:
PROCEDURE DBMS_AQ.AQ$_DEQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
SUBSCRIBER VARCHAR2 IN DEFAULT
MSGID RAW IN DEFAULT
CORRELATION VARCHAR2 IN DEFAULT
DEQUEUE_MODE BINARY_INTEGER IN DEFAULT
NAVIGATION BINARY_INTEGER IN DEFAULT
VISIBILITY BINARY_INTEGER IN DEFAULT
WAIT BINARY_INTEGER IN DEFAULT
ENQUEUE_TIME DATE OUT
STATE BINARY_INTEGER OUT
OUT_MSGID RAW OUT
OUT_CORRELATION VARCHAR2 OUT
PRIORITY BINARY_INTEGER OUT
DELAY BINARY_INTEGER OUT
EXPIRATION BINARY_INTEGER OUT
ATTEMPTS BINARY_INTEGER OUT
EXCEPTION_QUEUE VARCHAR2 OUT
REMOTE_RECIPIENTS TABLE OF AQ$_AGENT OUT
SENDER_NAME VARCHAR2 OUT
SENDER_ADDR VARCHAR2 OUT
SENDER_PROTOCOL BINARY_INTEGER OUT
ORIGINAL_MSGID RAW OUT
PAYLOAD_TYPE BINARY_INTEGER IN DEFAULT
RAW_USER_DATA RAW OUT
OBJECT_USER_DATA OUT
DEQ_CONDITION VARCHAR2 IN DEFAULT
SIGNATURE AQ$_SIG_PROP IN DEFAULT
OUT_SIGN AQ$_SIG_PROP OUT
TRANSFORMATION VARCHAR2 IN DEFAULT
BUFMESG_PROP BINARY_INTEGER IN DEFAULT
LCR2XML_CONVERT BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQ.AQ$_DEQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
SUBSCRIBER VARCHAR2 IN DEFAULT
MSGID RAW IN DEFAULT
CORRELATION VARCHAR2 IN DEFAULT
DEQUEUE_MODE BINARY_INTEGER IN DEFAULT
NAVIGATION BINARY_INTEGER IN DEFAULT
VISIBILITY BINARY_INTEGER IN DEFAULT
WAIT BINARY_INTEGER IN DEFAULT
ENQUEUE_TIME DATE OUT
STATE BINARY_INTEGER OUT
OUT_MSGID RAW OUT
OUT_CORRELATION VARCHAR2 OUT
PRIORITY BINARY_INTEGER OUT
DELAY BINARY_INTEGER OUT
EXPIRATION BINARY_INTEGER OUT
ATTEMPTS BINARY_INTEGER OUT
EXCEPTION_QUEUE VARCHAR2 OUT
REMOTE_RECIPIENTS TABLE OF AQ$_AGENT OUT
SENDER_NAME VARCHAR2 OUT
SENDER_ADDR VARCHAR2 OUT
SENDER_PROTOCOL BINARY_INTEGER OUT
ORIGINAL_MSGID RAW OUT
PAYLOAD_TYPE BINARY_INTEGER IN DEFAULT
RAW_USER_DATA RAW OUT
OBJECT_USER_DATA OUT
DEQ_CONDITION VARCHAR2 IN DEFAULT
SIGNATURE AQ$_SIG_PROP IN DEFAULT
OUT_SIGN AQ$_SIG_PROP OUT
TRANSFORMATION VARCHAR2 IN DEFAULT
BUFMESG_PROP BINARY_INTEGER IN DEFAULT
LCR2XML_CONVERT BOOLEAN IN DEFAULT
USER_PROPERTY ANYDATA OUT
PROCEDURE DBMS_AQ.AQ$_DEQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
SUBSCRIBER VARCHAR2 IN DEFAULT
MSGID RAW IN DEFAULT
CORRELATION VARCHAR2 IN DEFAULT
DEQUEUE_MODE BINARY_INTEGER IN DEFAULT
NAVIGATION BINARY_INTEGER IN DEFAULT
VISIBILITY BINARY_INTEGER IN DEFAULT
WAIT BINARY_INTEGER IN DEFAULT
ENQUEUE_TIME DATE OUT
STATE BINARY_INTEGER OUT
OUT_MSGID RAW OUT
OUT_CORRELATION VARCHAR2 OUT
PRIORITY BINARY_INTEGER OUT
DELAY BINARY_INTEGER OUT
EXPIRATION BINARY_INTEGER OUT
ATTEMPTS BINARY_INTEGER OUT
EXCEPTION_QUEUE VARCHAR2 OUT
REMOTE_RECIPIENTS TABLE OF AQ$_AGENT OUT
SENDER_NAME VARCHAR2 OUT
SENDER_ADDR VARCHAR2 OUT
SENDER_PROTOCOL BINARY_INTEGER OUT
ORIGINAL_MSGID RAW OUT
PAYLOAD_TYPE BINARY_INTEGER IN DEFAULT
RAW_USER_DATA RAW OUT
OBJECT_USER_DATA OUT
DEQ_CONDITION VARCHAR2 IN DEFAULT
SIGNATURE AQ$_SIG_PROP IN DEFAULT
OUT_SIGN AQ$_SIG_PROP OUT
TRANSFORMATION VARCHAR2 IN DEFAULT
BUFMESG_PROP BINARY_INTEGER IN DEFAULT
LCR2XML_CONVERT BOOLEAN IN DEFAULT
USER_PROPERTY ANYDATA OUT
DELIVERY_MODE BINARY_INTEGER IN DEFAULT
OUT_DELIVERY_MODE BINARY_INTEGER OUT
PROCEDURE DBMS_AQ.AQ$_ENQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
SENDER_NAME VARCHAR2 IN DEFAULT
SENDER_ADDR VARCHAR2 IN DEFAULT
SENDER_PROTOCOL BINARY_INTEGER IN DEFAULT
ORIGINAL_MSGID RAW IN DEFAULT
CORRELATION VARCHAR2 IN DEFAULT
VISIBILITY BINARY_INTEGER IN DEFAULT
PRIORITY BINARY_INTEGER IN DEFAULT
DELAY BINARY_INTEGER IN DEFAULT
EXPIRATION BINARY_INTEGER IN DEFAULT
RELATIVE_MSGID RAW IN DEFAULT
SEQUENCE_DEVIATION BINARY_INTEGER IN DEFAULT
EXCEPTION_QUEUE VARCHAR2 IN DEFAULT
RECIPIENTS TABLE OF AQ$_AGENT IN
PAYLOAD_TYPE BINARY_INTEGER IN DEFAULT
RAW_USER_DATA RAW IN DEFAULT
OBJECT_USER_DATA IN
MSGID RAW OUT
SIGNATURE AQ$_SIG_PROP IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
BUFMESG_PROP BINARY_INTEGER IN DEFAULT
ANYDATA_CONVERT BOOLEAN IN DEFAULT
LCR2XML_CONVERT BOOLEAN IN DEFAULT
USER_PROPERTY ANYDATA IN DEFAULT
DELIVERY_MODE BINARY_INTEGER IN DEFAULT
PROCEDURE DBMS_AQ.BIND_AGENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT AQ$_AGENT IN
CERTIFICATE_LOCATION VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQ.DEQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
DEQUEUE_OPTIONS RECORD IN
CONSUMER_NAME VARCHAR2(30) IN
DEQUEUE_MODE BINARY_INTEGER IN
NAVIGATION BINARY_INTEGER IN
VISIBILITY BINARY_INTEGER IN
WAIT BINARY_INTEGER IN
MSGID RAW(16) IN
CORRELATION VARCHAR2(128) IN
DEQ_CONDITION VARCHAR2(4000) IN
SIGNATURE AQ$_SIG_PROP IN
TRANSFORMATION VARCHAR2(61) IN
BUFMESG_PROP BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
MESSAGE_PROPERTIES RECORD OUT
PRIORITY BINARY_INTEGER OUT
DELAY BINARY_INTEGER OUT
EXPIRATION BINARY_INTEGER OUT
CORRELATION VARCHAR2(128) OUT
ATTEMPTS BINARY_INTEGER OUT
RECIPIENT_LIST TABLE OF AQ$_AGENT OUT
EXCEPTION_QUEUE VARCHAR2(61) OUT
ENQUEUE_TIME DATE OUT
STATE BINARY_INTEGER OUT
SENDER_ID AQ$_AGENT OUT
ORIGINAL_MSGID RAW(16) OUT
SIGNATURE AQ$_SIG_PROP OUT
TRANSACTION_GROUP VARCHAR2(30) OUT
USER_PROPERTY ANYDATA OUT
DELIVERY_MODE BINARY_INTEGER OUT
PAYLOAD OUT
MSGID RAW OUT
PROCEDURE DBMS_AQ.DEQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
DEQUEUE_OPTIONS RECORD IN
CONSUMER_NAME VARCHAR2(30) IN
DEQUEUE_MODE BINARY_INTEGER IN
NAVIGATION BINARY_INTEGER IN
VISIBILITY BINARY_INTEGER IN
WAIT BINARY_INTEGER IN
MSGID RAW(16) IN
CORRELATION VARCHAR2(128) IN
DEQ_CONDITION VARCHAR2(4000) IN
SIGNATURE AQ$_SIG_PROP IN
TRANSFORMATION VARCHAR2(61) IN
BUFMESG_PROP BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
MESSAGE_PROPERTIES RECORD OUT
PRIORITY BINARY_INTEGER OUT
DELAY BINARY_INTEGER OUT
EXPIRATION BINARY_INTEGER OUT
CORRELATION VARCHAR2(128) OUT
ATTEMPTS BINARY_INTEGER OUT
RECIPIENT_LIST TABLE OF AQ$_AGENT OUT
EXCEPTION_QUEUE VARCHAR2(61) OUT
ENQUEUE_TIME DATE OUT
STATE BINARY_INTEGER OUT
SENDER_ID AQ$_AGENT OUT
ORIGINAL_MSGID RAW(16) OUT
SIGNATURE AQ$_SIG_PROP OUT
TRANSACTION_GROUP VARCHAR2(30) OUT
USER_PROPERTY ANYDATA OUT
DELIVERY_MODE BINARY_INTEGER OUT
PAYLOAD OUT
MSGID RAW OUT
PROCEDURE DBMS_AQ.DEQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
DEQUEUE_OPTIONS RECORD IN
CONSUMER_NAME VARCHAR2(30) IN
DEQUEUE_MODE BINARY_INTEGER IN
NAVIGATION BINARY_INTEGER IN
VISIBILITY BINARY_INTEGER IN
WAIT BINARY_INTEGER IN
MSGID RAW(16) IN
CORRELATION VARCHAR2(128) IN
DEQ_CONDITION VARCHAR2(4000) IN
SIGNATURE AQ$_SIG_PROP IN
TRANSFORMATION VARCHAR2(61) IN
BUFMESG_PROP BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
MESSAGE_PROPERTIES RECORD OUT
PRIORITY BINARY_INTEGER OUT
DELAY BINARY_INTEGER OUT
EXPIRATION BINARY_INTEGER OUT
CORRELATION VARCHAR2(128) OUT
ATTEMPTS BINARY_INTEGER OUT
RECIPIENT_LIST TABLE OF AQ$_AGENT OUT
EXCEPTION_QUEUE VARCHAR2(61) OUT
ENQUEUE_TIME DATE OUT
STATE BINARY_INTEGER OUT
SENDER_ID AQ$_AGENT OUT
ORIGINAL_MSGID RAW(16) OUT
SIGNATURE AQ$_SIG_PROP OUT
TRANSACTION_GROUP VARCHAR2(30) OUT
USER_PROPERTY ANYDATA OUT
DELIVERY_MODE BINARY_INTEGER OUT
PAYLOAD RAW OUT
MSGID RAW OUT
FUNCTION DBMS_AQ.DEQUEUE_ARRAY RETURNS BINARY_INTEGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
DEQUEUE_OPTIONS RECORD IN
CONSUMER_NAME VARCHAR2(30) IN
DEQUEUE_MODE BINARY_INTEGER IN
NAVIGATION BINARY_INTEGER IN
VISIBILITY BINARY_INTEGER IN
WAIT BINARY_INTEGER IN
MSGID RAW(16) IN
CORRELATION VARCHAR2(128) IN
DEQ_CONDITION VARCHAR2(4000) IN
SIGNATURE AQ$_SIG_PROP IN
TRANSFORMATION VARCHAR2(61) IN
BUFMESG_PROP BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
ARRAY_SIZE BINARY_INTEGER IN
MESSAGE_PROPERTIES_ARRAY MESSAGE_PROPERTIES_ARRAY_T OUT
PAYLOAD_ARRAY OUT
MSGID_ARRAY MSGID_ARRAY_T OUT
FUNCTION DBMS_AQ.DEQUEUE_ARRAY RETURNS BINARY_INTEGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
DEQUEUE_OPTIONS RECORD IN
CONSUMER_NAME VARCHAR2(30) IN
DEQUEUE_MODE BINARY_INTEGER IN
NAVIGATION BINARY_INTEGER IN
VISIBILITY BINARY_INTEGER IN
WAIT BINARY_INTEGER IN
MSGID RAW(16) IN
CORRELATION VARCHAR2(128) IN
DEQ_CONDITION VARCHAR2(4000) IN
SIGNATURE AQ$_SIG_PROP IN
TRANSFORMATION VARCHAR2(61) IN
BUFMESG_PROP BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
ARRAY_SIZE BINARY_INTEGER IN
MESSAGE_PROPERTIES_ARRAY MESSAGE_PROPERTIES_ARRAY_T OUT
PAYLOAD_ARRAY OUT
MSGID_ARRAY MSGID_ARRAY_T OUT
ERROR_ARRAY ERROR_ARRAY_T OUT
PROCEDURE DBMS_AQ.ENQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
ENQUEUE_OPTIONS RECORD IN
VISIBILITY BINARY_INTEGER IN
RELATIVE_MSGID RAW(16) IN
SEQUENCE_DEVIATION BINARY_INTEGER IN
TRANSFORMATION VARCHAR2(61) IN
BUFMESG_PROP BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
MESSAGE_PROPERTIES RECORD IN
PRIORITY BINARY_INTEGER IN
DELAY BINARY_INTEGER IN
EXPIRATION BINARY_INTEGER IN
CORRELATION VARCHAR2(128) IN
ATTEMPTS BINARY_INTEGER IN
RECIPIENT_LIST TABLE OF AQ$_AGENT IN
EXCEPTION_QUEUE VARCHAR2(61) IN
ENQUEUE_TIME DATE IN
STATE BINARY_INTEGER IN
SENDER_ID AQ$_AGENT IN
ORIGINAL_MSGID RAW(16) IN
SIGNATURE AQ$_SIG_PROP IN
TRANSACTION_GROUP VARCHAR2(30) IN
USER_PROPERTY ANYDATA IN
DELIVERY_MODE BINARY_INTEGER IN
PAYLOAD IN
MSGID RAW OUT
PROCEDURE DBMS_AQ.ENQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
ENQUEUE_OPTIONS RECORD IN
VISIBILITY BINARY_INTEGER IN
RELATIVE_MSGID RAW(16) IN
SEQUENCE_DEVIATION BINARY_INTEGER IN
TRANSFORMATION VARCHAR2(61) IN
BUFMESG_PROP BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
MESSAGE_PROPERTIES RECORD IN
PRIORITY BINARY_INTEGER IN
DELAY BINARY_INTEGER IN
EXPIRATION BINARY_INTEGER IN
CORRELATION VARCHAR2(128) IN
ATTEMPTS BINARY_INTEGER IN
RECIPIENT_LIST TABLE OF AQ$_AGENT IN
EXCEPTION_QUEUE VARCHAR2(61) IN
ENQUEUE_TIME DATE IN
STATE BINARY_INTEGER IN
SENDER_ID AQ$_AGENT IN
ORIGINAL_MSGID RAW(16) IN
SIGNATURE AQ$_SIG_PROP IN
TRANSACTION_GROUP VARCHAR2(30) IN
USER_PROPERTY ANYDATA IN
DELIVERY_MODE BINARY_INTEGER IN
PAYLOAD IN
MSGID RAW OUT
PROCEDURE DBMS_AQ.ENQUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
ENQUEUE_OPTIONS RECORD IN
VISIBILITY BINARY_INTEGER IN
RELATIVE_MSGID RAW(16) IN
SEQUENCE_DEVIATION BINARY_INTEGER IN
TRANSFORMATION VARCHAR2(61) IN
BUFMESG_PROP BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
MESSAGE_PROPERTIES RECORD IN
PRIORITY BINARY_INTEGER IN
DELAY BINARY_INTEGER IN
EXPIRATION BINARY_INTEGER IN
CORRELATION VARCHAR2(128) IN
ATTEMPTS BINARY_INTEGER IN
RECIPIENT_LIST TABLE OF AQ$_AGENT IN
EXCEPTION_QUEUE VARCHAR2(61) IN
ENQUEUE_TIME DATE IN
STATE BINARY_INTEGER IN
SENDER_ID AQ$_AGENT IN
ORIGINAL_MSGID RAW(16) IN
SIGNATURE AQ$_SIG_PROP IN
TRANSACTION_GROUP VARCHAR2(30) IN
USER_PROPERTY ANYDATA IN
DELIVERY_MODE BINARY_INTEGER IN
PAYLOAD RAW IN
MSGID RAW OUT
FUNCTION DBMS_AQ.ENQUEUE_ARRAY RETURNS BINARY_INTEGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
ENQUEUE_OPTIONS RECORD IN
VISIBILITY BINARY_INTEGER IN
RELATIVE_MSGID RAW(16) IN
SEQUENCE_DEVIATION BINARY_INTEGER IN
TRANSFORMATION VARCHAR2(61) IN
BUFMESG_PROP BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
ARRAY_SIZE BINARY_INTEGER IN
MESSAGE_PROPERTIES_ARRAY MESSAGE_PROPERTIES_ARRAY_T IN
PAYLOAD_ARRAY IN
MSGID_ARRAY MSGID_ARRAY_T OUT
FUNCTION DBMS_AQ.ENQUEUE_ARRAY RETURNS BINARY_INTEGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
ENQUEUE_OPTIONS RECORD IN
VISIBILITY BINARY_INTEGER IN
RELATIVE_MSGID RAW(16) IN
SEQUENCE_DEVIATION BINARY_INTEGER IN
TRANSFORMATION VARCHAR2(61) IN
BUFMESG_PROP BINARY_INTEGER IN
DELIVERY_MODE BINARY_INTEGER IN
ARRAY_SIZE BINARY_INTEGER IN
MESSAGE_PROPERTIES_ARRAY MESSAGE_PROPERTIES_ARRAY_T IN
PAYLOAD_ARRAY IN
MSGID_ARRAY MSGID_ARRAY_T OUT
ERROR_ARRAY ERROR_ARRAY_T OUT
PROCEDURE DBMS_AQ.LISTEN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT_LIST TABLE OF AQ$_AGENT IN
WAIT BINARY_INTEGER IN DEFAULT
AGENT AQ$_AGENT OUT
PROCEDURE DBMS_AQ.LISTEN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT_LIST TABLE OF AQ$_AGENT IN
WAIT BINARY_INTEGER IN DEFAULT
LISTEN_DELIVERY_MODE BINARY_INTEGER IN DEFAULT
AGENT AQ$_AGENT OUT
MESSAGE_DELIVERY_MODE BINARY_INTEGER OUT
PROCEDURE DBMS_AQ.POST
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
POST_LIST AQ$_POST_INFO_LIST IN
POST_COUNT NUMBER IN
PROCEDURE DBMS_AQ.REGISTER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
REG_LIST AQ$_REG_INFO_LIST IN
REG_COUNT NUMBER IN
PROCEDURE DBMS_AQ.UNBIND_AGENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT AQ$_AGENT IN
PROCEDURE DBMS_AQ.UNREGISTER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
REG_LIST AQ$_REG_INFO_LIST IN
REG_COUNT NUMBER IN
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
