 |
|
DBMS_AQJMS_INTERNAL package tips
Oracle Tips by Burleson Consulting |
DBMS_AQJMS_INTERNAL
<< Return to the index
Oracle 11g provides the following information about the DBMS_AQJMS_INTERNAL package:
Description of the DBMS_AQJMS_INTERNAL package:
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_GET_PROP_STAT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QID BINARY_INTEGER IN
DB_LINK VARCHAR2 IN
SEQUENCE_NUMBER BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_GET_TRANS_TYPE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TRANS_SCHEMA VARCHAR2 IN
TRANS_NAME VARCHAR2 IN
SRC_TYPE VARCHAR2 OUT
DEST_TYPE VARCHAR2 OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_DEQUEUE_BYTES_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
NUM_MESSAGES BINARY_INTEGER IN
CONSUMER_NAME VARCHAR2 IN DEFAULT
DEQUEUE_MODE BINARY_INTEGER IN DEFAULT
NAVIGATION BINARY_INTEGER IN DEFAULT
VISIBILITY BINARY_INTEGER IN DEFAULT
WAIT BINARY_INTEGER IN DEFAULT
CORRELATION VARCHAR2 IN DEFAULT
DEQ_CONDITION VARCHAR2 IN DEFAULT
SIGNATURE AQ$_SIG_PROP IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES OUT
MESSAGES AQ$_JMS_BYTES_MESSAGES OUT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
NUM_DEQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_DEQUEUE_MAP_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
NUM_MESSAGES BINARY_INTEGER IN
CONSUMER_NAME VARCHAR2 IN DEFAULT
DEQUEUE_MODE BINARY_INTEGER IN DEFAULT
NAVIGATION BINARY_INTEGER IN DEFAULT
VISIBILITY BINARY_INTEGER IN DEFAULT
WAIT BINARY_INTEGER IN DEFAULT
CORRELATION VARCHAR2 IN DEFAULT
DEQ_CONDITION VARCHAR2 IN DEFAULT
SIGNATURE AQ$_SIG_PROP IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES OUT
MESSAGES AQ$_JMS_MAP_MESSAGES OUT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
NUM_DEQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_DEQUEUE_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
NUM_MESSAGES BINARY_INTEGER IN
CONSUMER_NAME VARCHAR2 IN DEFAULT
DEQUEUE_MODE BINARY_INTEGER IN DEFAULT
NAVIGATION BINARY_INTEGER IN DEFAULT
VISIBILITY BINARY_INTEGER IN DEFAULT
WAIT BINARY_INTEGER IN DEFAULT
CORRELATION VARCHAR2 IN DEFAULT
DEQ_CONDITION VARCHAR2 IN DEFAULT
SIGNATURE AQ$_SIG_PROP IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES OUT
MESSAGES AQ$_JMS_MESSAGES OUT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
NUM_DEQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_DEQUEUE_OBJ_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
NUM_MESSAGES BINARY_INTEGER IN
CONSUMER_NAME VARCHAR2 IN DEFAULT
DEQUEUE_MODE BINARY_INTEGER IN DEFAULT
NAVIGATION BINARY_INTEGER IN DEFAULT
VISIBILITY BINARY_INTEGER IN DEFAULT
WAIT BINARY_INTEGER IN DEFAULT
CORRELATION VARCHAR2 IN DEFAULT
DEQ_CONDITION VARCHAR2 IN DEFAULT
SIGNATURE AQ$_SIG_PROP IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES OUT
MESSAGES AQ$_JMS_OBJECT_MESSAGES OUT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
NUM_DEQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_DEQUEUE_STR_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
NUM_MESSAGES BINARY_INTEGER IN
CONSUMER_NAME VARCHAR2 IN DEFAULT
DEQUEUE_MODE BINARY_INTEGER IN DEFAULT
NAVIGATION BINARY_INTEGER IN DEFAULT
VISIBILITY BINARY_INTEGER IN DEFAULT
WAIT BINARY_INTEGER IN DEFAULT
CORRELATION VARCHAR2 IN DEFAULT
DEQ_CONDITION VARCHAR2 IN DEFAULT
SIGNATURE AQ$_SIG_PROP IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES OUT
MESSAGES AQ$_JMS_STREAM_MESSAGES OUT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
NUM_DEQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_DEQUEUE_TEXT_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
NUM_MESSAGES BINARY_INTEGER IN
CONSUMER_NAME VARCHAR2 IN DEFAULT
DEQUEUE_MODE BINARY_INTEGER IN DEFAULT
NAVIGATION BINARY_INTEGER IN DEFAULT
VISIBILITY BINARY_INTEGER IN DEFAULT
WAIT BINARY_INTEGER IN DEFAULT
CORRELATION VARCHAR2 IN DEFAULT
DEQ_CONDITION VARCHAR2 IN DEFAULT
SIGNATURE AQ$_SIG_PROP IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES OUT
MESSAGES AQ$_JMS_TEXT_MESSAGES OUT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
NUM_DEQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_ENQUEUE_BYTES_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
MESSAGES AQ$_JMS_BYTES_MESSAGES IN
NUM_MESSAGES BINARY_INTEGER IN
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES IN
VISIBILITY BINARY_INTEGER IN DEFAULT
RELATIVE_MSGID RAW IN DEFAULT
SEQUENCE_DEVIATION BINARY_INTEGER IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
ERRORS AQ$_JMS_ARRAY_ERRORS OUT
NUM_ENQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_ENQUEUE_MAP_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
MESSAGES AQ$_JMS_MAP_MESSAGES IN
NUM_MESSAGES BINARY_INTEGER IN
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES IN
VISIBILITY BINARY_INTEGER IN DEFAULT
RELATIVE_MSGID RAW IN DEFAULT
SEQUENCE_DEVIATION BINARY_INTEGER IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
ERRORS AQ$_JMS_ARRAY_ERRORS OUT
NUM_ENQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_ENQUEUE_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
MESSAGES AQ$_JMS_MESSAGES IN
NUM_MESSAGES BINARY_INTEGER IN
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES IN
VISIBILITY BINARY_INTEGER IN DEFAULT
RELATIVE_MSGID RAW IN DEFAULT
SEQUENCE_DEVIATION BINARY_INTEGER IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
ERRORS AQ$_JMS_ARRAY_ERRORS OUT
NUM_ENQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_ENQUEUE_OBJ_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
MESSAGES AQ$_JMS_OBJECT_MESSAGES IN
NUM_MESSAGES BINARY_INTEGER IN
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES IN
VISIBILITY BINARY_INTEGER IN DEFAULT
RELATIVE_MSGID RAW IN DEFAULT
SEQUENCE_DEVIATION BINARY_INTEGER IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
ERRORS AQ$_JMS_ARRAY_ERRORS OUT
NUM_ENQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_ENQUEUE_STR_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
MESSAGES AQ$_JMS_STREAM_MESSAGES IN
NUM_MESSAGES BINARY_INTEGER IN
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES IN
VISIBILITY BINARY_INTEGER IN DEFAULT
RELATIVE_MSGID RAW IN DEFAULT
SEQUENCE_DEVIATION BINARY_INTEGER IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
ERRORS AQ$_JMS_ARRAY_ERRORS OUT
NUM_ENQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_JMS_ENQUEUE_TEXT_MESSAGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
MESSAGES AQ$_JMS_TEXT_MESSAGES IN
NUM_MESSAGES BINARY_INTEGER IN
MESSAGE_PROPS AQ$_JMS_MESSAGE_PROPERTIES IN
VISIBILITY BINARY_INTEGER IN DEFAULT
RELATIVE_MSGID RAW IN DEFAULT
SEQUENCE_DEVIATION BINARY_INTEGER IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
MSGIDS AQ$_JMS_ARRAY_MSGIDS OUT
ERRORS AQ$_JMS_ARRAY_ERRORS OUT
NUM_ENQUEUED BINARY_INTEGER OUT
PROCEDURE DBMS_AQJMS_INTERNAL.AQ$_UPDATE_PROP_STAT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QID BINARY_INTEGER IN
DB_LINK VARCHAR2 IN
SEQUENCE_NUMBER BINARY_INTEGER IN
STATUS_CODE BINARY_INTEGER IN
PROCEDURE DBMS_AQJMS_INTERNAL.GET_DB_USERNAME_FOR_AGENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT_NAME VARCHAR2 IN
OWNER_NAME VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
OPERATION BINARY_INTEGER IN
CURR_DB_USER VARCHAR2 IN DEFAULT
DB_USERNAME VARCHAR2 OUT
ENQ_PRIV BINARY_INTEGER OUT
DEQ_PRIV BINARY_INTEGER OUT
 |
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
|
|
