 |
|
DBMS_AQADM_SYS package tips
Oracle Tips by Burleson Consulting |
DBMS_AQADM_SYS
<< Return to the index
Related notes on DBMS_AQADM_SYS:
Oracle 11g provides the following information about the DBMS_AQADM_SYS package:
Description of the DBMS_AQADM_SYS package:
PROCEDURE DBMS_AQADM_SYS.ADD_ALIAS_TO_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
ALIAS VARCHAR2 IN
OBJ_LOCATION VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.ADD_BUFFER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
MEMORY_THRESHOLD BINARY_INTEGER IN DEFAULT
COMMIT_TXN BOOLEAN IN DEFAULT
FLOW_CONTROL BINARY_INTEGER IN DEFAULT
DEFER_DDL BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ADD_BUFFER_TABLES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
Q_SCHEMA VARCHAR2 IN
Q_NAME VARCHAR2 IN
QTNAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.ADD_CONNECTION_TO_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CONNECTION VARCHAR2 IN
HOST VARCHAR2 IN
PORT BINARY_INTEGER IN
SID VARCHAR2 IN
DRIVER VARCHAR2 IN DEFAULT
TYPE BINARY_INTEGER IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ADD_CONNECTION_TO_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CONNECTION VARCHAR2 IN
JDBC_STRING VARCHAR2 IN
USERNAME VARCHAR2 IN DEFAULT
PASSWORD VARCHAR2 IN DEFAULT
TYPE BINARY_INTEGER IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ADD_DB_LINK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DBL_NAME VARCHAR2 IN
CONN_STR VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.ADD_QTAB_EXPDEP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
TABLE_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.ADD_QUEUE_TAB_TO_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_TAB_SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
PAYLOAD_TYPE VARCHAR2 IN
MULTIPLE_CONSUMERS BOOLEAN IN DEFAULT
MESSAGE_GROUPING BINARY_INTEGER IN DEFAULT
PRIMARY_INSTANCE BINARY_INTEGER IN DEFAULT
SECONDARY_INSTANCE BINARY_INTEGER IN DEFAULT
COMPATIBILITY VARCHAR2 IN DEFAULT
COMMENT VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ADD_QUEUE_TO_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_SCHEMA VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
QT_SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
QUEUE_TYPE BINARY_INTEGER IN
MAX_RETRIES BINARY_INTEGER IN DEFAULT
RETRY_DELAY BINARY_INTEGER IN DEFAULT
RETENTION_TIME BINARY_INTEGER IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ADD_SPILLED_IOT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QSCHEMA VARCHAR2 IN
QTABLE VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.ADD_SPILLED_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QSCHEMA VARCHAR2 IN
QTABLE VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.ADD_SUBSCRIBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
SUBSCRIBER AQ$_AGENT IN
RULE VARCHAR2 IN DEFAULT
SECURITY_CHECK BOOLEAN IN DEFAULT
IN_RECURSIVE_TXN BOOLEAN IN DEFAULT
ADD_JMS_ENTRY BOOLEAN IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
RULESET VARCHAR2 IN DEFAULT
NEGATIVE_RULESET VARCHAR2 IN DEFAULT
PROPERTIES NUMBER IN DEFAULT
NAME_CANONICALIZED BOOLEAN IN DEFAULT
QUEUE_TO_QUEUE BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ADD_SUBSCRIBER_TO_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_SCHEMA VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
SUBSCRIBER AQ$_AGENT IN
ADD_JMS_ENTRY BOOLEAN IN DEFAULT
RULE VARCHAR2 IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ALTER_AQ_AGENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT_NAME VARCHAR2 IN
CERTIFICATE_LOCATION VARCHAR2 IN DEFAULT
ENABLE_HTTP BOOLEAN IN DEFAULT
ENABLE_SMTP BOOLEAN IN DEFAULT
ENABLE_ANYP BOOLEAN IN DEFAULT
NAME_CANONICALIZED BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ALTER_QUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
MAX_RETRIES NUMBER IN DEFAULT
RETRY_DELAY NUMBER IN DEFAULT
RETENTION_TIME NUMBER IN DEFAULT
AUTO_COMMIT BOOLEAN IN DEFAULT
COMMENT VARCHAR2 IN DEFAULT
FLOW_CONTROL BINARY_INTEGER IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ALTER_QUEUE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_TABLE VARCHAR2 IN
COMMENT VARCHAR2 IN DEFAULT
PRIMARY_INSTANCE BINARY_INTEGER IN DEFAULT
SECONDARY_INSTANCE BINARY_INTEGER IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ALTER_SUBSCRIBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
SUBSCRIBER AQ$_AGENT IN
RULE VARCHAR2 IN
SECURITY_CHECK BOOLEAN IN DEFAULT
IN_RECURSIVE_TXN BOOLEAN IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
COMPATIBLE VARCHAR2 IN DEFAULT
RULESET VARCHAR2 IN DEFAULT
NEGATIVE_RULESET VARCHAR2 IN DEFAULT
NAME_CANONICALIZED BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.AQ$_PROPAGATION_PROCEDURE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
JOB_OWNER VARCHAR2 IN
JOB_NAME VARCHAR2 IN
SOURCE_QUEUE VARCHAR2 IN
DEST VARCHAR2 IN
DURATION VARCHAR2 IN
LATENCY VARCHAR2 IN
HTTP_BATCH_SIZE VARCHAR2 IN
IDLE_TIMEOUT VARCHAR2 IN
DEQUEUE_TIMEOUT VARCHAR2 IN
TRACE_LEVEL VARCHAR2 IN
FUNCTION DBMS_AQADM_SYS.AQ$_PROPAQ RETURNS DATE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
JOB NUMBER IN
FUNCTION DBMS_AQADM_SYS.BFQ RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QPROPERTIES NUMBER IN
FUNCTION DBMS_AQADM_SYS.CHK_QT_FLG RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
FLAG NUMBER IN
PROCEDURE DBMS_AQADM_SYS.CLR_QT_FLG
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN/OUT
FLAG NUMBER IN
FUNCTION DBMS_AQADM_SYS.CNF RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
FUNCTION DBMS_AQADM_SYS.COMPATIBLE_100 RETURNS BOOLEAN
FUNCTION DBMS_AQADM_SYS.COMPUTE_NAME RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QSCHEMA VARCHAR2 IN
OBNAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.CREATE_AQ_AGENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT_NAME VARCHAR2 IN
CERTIFICATE_LOCATION VARCHAR2 IN DEFAULT
ENABLE_HTTP BOOLEAN IN DEFAULT
ENABLE_SMTP BOOLEAN IN DEFAULT
ENABLE_ANYP BOOLEAN IN DEFAULT
NAME_CANONICALIZED BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.CREATE_BASE_VIEW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
QT_FLAGS NUMBER IN
PROCEDURE DBMS_AQADM_SYS.CREATE_BUFFER_VIEW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
IG_ERR BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.CREATE_BUFFER_VIEW101
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
IG_ERR BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.CREATE_DEQ_VIEW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
QT_FLAGS NUMBER IN
PROCEDURE DBMS_AQADM_SYS.CREATE_NP_QUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
MULTIPLE_CONSUMERS BOOLEAN IN DEFAULT
COMMENT VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.CREATE_PROP_VIEWS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PROP_STYLE BOOLEAN IN
PROCEDURE DBMS_AQADM_SYS.CREATE_QT_DICTIONARY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
USER_DATA_TYPE NUMBER(38) IN
QT_FLAGS NUMBER(38) IN
SORT_COLS VARCHAR2 IN
PRIMARY_INSTANCE BINARY_INTEGER IN
SECONDARY_INSTANCE BINARY_INTEGER IN
QT_COMMENT VARCHAR2 IN
QT_TIMEZONE VARCHAR2 IN
OWNER_INSTANCE BINARY_INTEGER OUT
PROCEDURE DBMS_AQADM_SYS.CREATE_QUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
QUEUE_TYPE BINARY_INTEGER IN DEFAULT
MAX_RETRIES NUMBER IN DEFAULT
RETRY_DELAY NUMBER IN DEFAULT
RETENTION_TIME NUMBER IN DEFAULT
DEPENDENCY_TRACKING BOOLEAN IN DEFAULT
COMMENT VARCHAR2 IN DEFAULT
AUTO_COMMIT BOOLEAN IN DEFAULT
EXTERNAL BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.CREATE_QUEUE_TABLE_TZ
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_TABLE VARCHAR2 IN
QUEUE_PAYLOAD_TYPE VARCHAR2 IN
STORAGE_CLAUSE VARCHAR2 IN DEFAULT
SORT_LIST VARCHAR2 IN DEFAULT
MULTIPLE_CONSUMERS BOOLEAN IN DEFAULT
MESSAGE_GROUPING BINARY_INTEGER IN DEFAULT
COMMENT VARCHAR2 IN DEFAULT
AUTO_COMMIT BOOLEAN IN DEFAULT
PRIMARY_INSTANCE BINARY_INTEGER IN DEFAULT
SECONDARY_INSTANCE BINARY_INTEGER IN DEFAULT
COMPATIBLE VARCHAR2 IN DEFAULT
NON_REPUDIATION BINARY_INTEGER IN DEFAULT
SECURE BOOLEAN IN DEFAULT
QUEUE_TABLE_TZ VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.CREATE_SPILLED_TABLES_IOTS
FUNCTION DBMS_AQADM_SYS.CTQT RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SORT_COLS NUMBER IN
PROCEDURE DBMS_AQADM_SYS.DBLINK_INFO
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DBLINK VARCHAR2 IN
QSCHEMA VARCHAR2 IN
PROTOCOL BINARY_INTEGER OUT
URL VARCHAR2 OUT
USERNAME VARCHAR2 OUT
PASSWD VARCHAR2 OUT
PROCEDURE DBMS_AQADM_SYS.DEL_ALIAS_FROM_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
ALIAS VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.DEL_CONNECTION_FROM_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CONNECTION VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.DEL_QUEUE_FROM_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_SCHEMA VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.DEL_SUBSCRIBER_FROM_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_SCHEMA VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
SUBSCRIBER AQ$_AGENT IN
DEL_JMS_ENTRY BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.DISABLE_DB_ACCESS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT_NAME VARCHAR2 IN
DB_USERNAME VARCHAR2 IN
NAMES_CANONICALIZED BOOLEAN IN
PROCEDURE DBMS_AQADM_SYS.DISABLE_DB_ACCESS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT_NAME VARCHAR2 IN
DB_USERNAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.DROP_AQ_AGENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT_NAME VARCHAR2 IN
NAME_CANONICALIZED BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.DROP_BUFFER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
FORCE BOOLEAN IN DEFAULT
COMMIT_TXN BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.DROP_BUFFER_VIEW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.DROP_QTAB_EXPDEP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
TABLE_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.DROP_QUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
AUTO_COMMIT BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.DROP_QUEUE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_TABLE VARCHAR2 IN
FORCE BOOLEAN IN DEFAULT
AUTO_COMMIT BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.DROP_QUEUE_TAB_FROM_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_TAB_SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.DROP_SPILLED_IOT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QSCHEMA VARCHAR2 IN
QTABLE VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.DROP_SPILLED_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QSCHEMA VARCHAR2 IN
QTABLE VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.DUMP_TRACE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MESSAGE VARCHAR2 IN
TIME_INFO BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.ENABLE_DB_ACCESS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT_NAME VARCHAR2 IN
DB_USERNAME VARCHAR2 IN
NAMES_CANONICALIZED BOOLEAN IN
PROCEDURE DBMS_AQADM_SYS.ENABLE_JMS_TYPES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_TABLE VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.EXECUTE_STMT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CLIENT_STMT VARCHAR2 IN
IGNORE_DDL_DML_ERROR BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.GET_CORR_MSG
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QID BINARY_INTEGER IN
SENDER_AGENT AQ$_AGENT IN
CORRELATION VARCHAR2 OUT
PROCEDURE DBMS_AQADM_SYS.GET_PROCNAME
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PROC_NAME VARCHAR2 OUT
SESS_ID NUMBER OUT
SESS_SERIAL NUMBER OUT
PROCEDURE DBMS_AQADM_SYS.GET_PROP_SEQNO
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QID BINARY_INTEGER IN
DQNAME VARCHAR2 IN
DBNAME VARCHAR2 IN
SEQ BINARY_INTEGER OUT
PROCEDURE DBMS_AQADM_SYS.GET_QUEUE_TABLE_NAME
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
NAME VARCHAR2 IN
QT_NAME VARCHAR2 OUT
PROCEDURE DBMS_AQADM_SYS.GET_REMOTE_QTYPE_INFO_TTC
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_DEST VARCHAR2 IN
DEST_SCHEMA VARCHAR2 IN
DEST_QNAME VARCHAR2 IN
RC BINARY_INTEGER IN/OUT
DEST_TOID RAW IN/OUT
DEST_VERSION NUMBER IN/OUT
DEST_TDS LONG RAW IN/OUT
QUEUE_STYLE VARCHAR2 IN/OUT
NETWORK_NAME VARCHAR2 OUT
PROCEDURE DBMS_AQADM_SYS.GET_SCHEMA_OID
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
DESTINATION VARCHAR2 IN
DESTINATION_QUEUE VARCHAR2 IN
QNAME VARCHAR2 OUT
QSCHEMA VARCHAR2 OUT
MYOID RAW OUT
MYDATA_TYPE NUMBER OUT
QT_FLAGS NUMBER(38) OUT
CANON_DEST VARCHAR2 OUT
QTYPE NUMBER OUT
FUNCTION DBMS_AQADM_SYS.GET_SEQ_NXTVAL RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SEQUENCE_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.GET_TRANS_INFO
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TRANSFORMATION VARCHAR2 IN
TRANS_SRC_TOID RAW IN/OUT
TRANS_SRC_VER NUMBER IN/OUT
TRANS_DEST_TOID RAW IN/OUT
TRANS_DEST_VER NUMBER IN/OUT
TRANS_DEST_TDS RAW IN/OUT
PROCEDURE DBMS_AQADM_SYS.GET_TYPE_INFO
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
QNAME VARCHAR2 IN
GETTDS BOOLEAN IN
RC BINARY_INTEGER OUT
TOID RAW OUT
VERSION NUMBER OUT
TDS LONG RAW OUT
QUEUE_STYLE VARCHAR2 OUT
NETWORK_NAME VARCHAR2 OUT
PROCEDURE DBMS_AQADM_SYS.GRANT_QUEUE_PRIVILEGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PRIVILEGE VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
GRANTEE VARCHAR2 IN
GRANT_OPTION BOOLEAN IN DEFAULT
GRANTOR VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.GRANT_SYSTEM_PRIVILEGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PRIVILEGE VARCHAR2 IN
GRANTEE VARCHAR2 IN
ADMIN_OPTION BOOLEAN IN DEFAULT
GRANTOR VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.GRANT_TYPE_ACCESS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
USER_NAME VARCHAR2 IN
FUNCTION DBMS_AQADM_SYS.IMPPEND_FLAG_CLEAR RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
FUNCTION DBMS_AQADM_SYS.IN_DATAPUMP_IMPORT RETURNS BOOLEAN
PROCEDURE DBMS_AQADM_SYS.ISALIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INSTANCE_NO BINARY_INTEGER IN
STATUS BINARY_INTEGER OUT
PROCEDURE DBMS_AQADM_SYS.I_BIND_AGENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT AQ$_AGENT IN
CERTIFICATE_LOCATION VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.I_CREATE_QT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_TABLE VARCHAR2 IN
QUEUE_PAYLOAD_TYPE VARCHAR2 IN DEFAULT
STORAGE_CLAUSE VARCHAR2 IN DEFAULT
SORT_LIST VARCHAR2 IN DEFAULT
MULTIPLE_CONSUMERS BOOLEAN IN DEFAULT
MESSAGE_GROUPING BINARY_INTEGER IN DEFAULT
PRIMARY_INSTANCE BINARY_INTEGER IN DEFAULT
SECONDARY_INSTANCE BINARY_INTEGER IN DEFAULT
COMMENT VARCHAR2 IN DEFAULT
COMPATIBLE VARCHAR2 IN DEFAULT
AUTO_COMMIT BOOLEAN IN DEFAULT
EXTERNAL BOOLEAN IN DEFAULT
NON_REPUDIATION BINARY_INTEGER IN DEFAULT
SECURE BOOLEAN IN DEFAULT
QUEUE_TABLE_TZ VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.I_UNBIND_AGENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGENT AQ$_AGENT IN
PROCEDURE DBMS_AQADM_SYS.KWQAQPDHASLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_SCHEMA VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
CONTAINS_LOB BOOLEAN OUT
FUNCTION DBMS_AQADM_SYS.MATCH_TDS RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC_TOID RAW IN
SRC_TDS RAW IN
DEST_TOID RAW IN
DEST_TDS RAW IN
SRC_SCHEMA VARCHAR2 IN
SRC_QNAME VARCHAR2 IN
VERIFIED VARCHAR2 OUT
FUNCTION DBMS_AQADM_SYS.MCQ RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
FUNCTION DBMS_AQADM_SYS.MCQ_8_0 RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
FUNCTION DBMS_AQADM_SYS.MCQ_8_1 RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
PROCEDURE DBMS_AQADM_SYS.MIGRATE_QUEUE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_TABLE VARCHAR2 IN
COMPATIBLE VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.MOD_QUEUE_IN_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_SCHEMA VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
MAX_RETRIES BINARY_INTEGER IN DEFAULT
RETRY_DELAY BINARY_INTEGER IN DEFAULT
RETENTION_TIME BINARY_INTEGER IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.MOD_QUEUE_TAB_IN_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_TAB_SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
PRIMARY_INSTANCE BINARY_INTEGER IN DEFAULT
SECONDARY_INSTANCE BINARY_INTEGER IN DEFAULT
COMMENT VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.MOD_SUBSCRIBER_IN_LDAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_SCHEMA VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
SUBSCRIBER AQ$_AGENT IN
RULE VARCHAR2 IN DEFAULT
TRANSFORMATION VARCHAR2 IN DEFAULT
FUNCTION DBMS_AQADM_SYS.NEWQ_10_1 RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
FUNCTION DBMS_AQADM_SYS.NEWQ_8_1 RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
PROCEDURE DBMS_AQADM_SYS.PARSE_NAME
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME_TYPE BINARY_INTEGER IN
FULL_NAME VARCHAR2 IN
SCHEMA VARCHAR2 OUT
NAME VARCHAR2 OUT
DBLINK_DB VARCHAR2 OUT
DBLINK_DOM VARCHAR2 OUT
EXTERNAL BOOLEAN IN DEFAULT
DEFAULT_SCHEMA VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.PATCH_DEQUEUE_IOT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.PATCH_HISTORY_IOT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.PATCH_QUEUE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
QT_FLAGS NUMBER IN
SORT_BY_EQT BOOLEAN IN
UPGRADE_TABLE BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.PATCH_QUEUE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.PATCH_TIMEMGR_IOT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.PRS_CMT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RESPONSE VARCHAR2 IN
STATUS NUMBER OUT
ERR_CODE NUMBER OUT
ERR_MSG VARCHAR2 OUT
PROCEDURE DBMS_AQADM_SYS.PRS_QTYP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RESPONSE VARCHAR2 IN
TOID RAW OUT
VERSION NUMBER OUT
TDS RAW OUT
RC NUMBER OUT
STATUS NUMBER OUT
ERR_CODE NUMBER OUT
ERR_MSG VARCHAR2 OUT
PROCEDURE DBMS_AQADM_SYS.PRS_RBK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RESPONSE VARCHAR2 IN
STATUS NUMBER OUT
ERR_CODE NUMBER OUT
ERR_MSG VARCHAR2 OUT
PROCEDURE DBMS_AQADM_SYS.PRS_SEQ
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RESPONSE VARCHAR2 IN
SEQ_NUM NUMBER OUT
STATUS NUMBER OUT
ERR_CODE NUMBER OUT
ERR_MSG VARCHAR2 OUT
PROCEDURE DBMS_AQADM_SYS.PURGE_BUFFER_QUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
PURGE_CONDITION VARCHAR2 IN
PURGE_OPTIONS RECORD IN
BLOCK BOOLEAN IN
DELIVERY_MODE BINARY_INTEGER IN
PROCEDURE DBMS_AQADM_SYS.PURGE_QUEUE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_TABLE VARCHAR2 IN
PURGE_CONDITION VARCHAR2 IN
PURGE_OPTIONS RECORD IN
BLOCK BOOLEAN IN
DELIVERY_MODE BINARY_INTEGER IN
FUNCTION DBMS_AQADM_SYS.QT_BUFQ_COUNT RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TOBJNO NUMBER IN
FUNCTION DBMS_AQADM_SYS.QUEUE_SUBSCRIBERS RETURNS TABLE OF AQ$_AGENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.REGISTER_DRIVER
PROCEDURE DBMS_AQADM_SYS.REMOVE_DB_LINK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DBL_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.REMOVE_ORPHMSGS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CURRENT_INSTANCE BINARY_INTEGER IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.REMOVE_SUBSCRIBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
SUBSCRIBER AQ$_AGENT IN
SECURITY_CHECK BOOLEAN IN DEFAULT
IN_RECURSIVE_TXN BOOLEAN IN DEFAULT
PARENT_TXN_ID VARCHAR2 IN DEFAULT
DEL_JMS_ENTRY BOOLEAN IN DEFAULT
NAME_CANONICALIZED BOOLEAN IN DEFAULT
ORPHANED_MESSAGES_SUB NUMBER IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.RESET_CORR_MSG
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QID BINARY_INTEGER IN
SENDER_AGENT AQ$_AGENT IN
PROCEDURE DBMS_AQADM_SYS.REVOKE_QUEUE_PRIVILEGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PRIVILEGE VARCHAR2 IN
QUEUE_NAME VARCHAR2 IN
GRANTEE VARCHAR2 IN
GRANTOR VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.REVOKE_SYSTEM_PRIVILEGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PRIVILEGE VARCHAR2 IN
GRANTEE VARCHAR2 IN
GRANTOR VARCHAR2 IN DEFAULT
FUNCTION DBMS_AQADM_SYS.RULESET_EXISTS RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RULESET_SCHEMA VARCHAR2 IN
RULESET_NAME VARCHAR2 IN
FUNCTION DBMS_AQADM_SYS.SCQ_8_0 RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
FUNCTION DBMS_AQADM_SYS.SCQ_8_1 RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
FUNCTION DBMS_AQADM_SYS.SECURE_QT RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
PROCEDURE DBMS_AQADM_SYS.START_QUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
ENQUEUE BOOLEAN IN DEFAULT
DEQUEUE BOOLEAN IN DEFAULT
EXTERNAL BOOLEAN IN DEFAULT
PROCEDURE DBMS_AQADM_SYS.STOP_QUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
ENQUEUE BOOLEAN IN DEFAULT
DEQUEUE BOOLEAN IN DEFAULT
WAIT BOOLEAN IN DEFAULT
FUNCTION DBMS_AQADM_SYS.TGQ RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_FLAGS NUMBER IN
PROCEDURE DBMS_AQADM_SYS.THROW_ERROR
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
ERRNO BINARY_INTEGER IN
Q_NAME VARCHAR2 IN
FUNCTION DBMS_AQADM_SYS.TRANSFORMATION_EXISTS RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TRANS_SCHEMA VARCHAR2 IN
TRANS_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.VALIDATE_QTAB_QUEUES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QT_SCHEMA VARCHAR2 IN
QT_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.VALIDATE_QUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
Q_SCHEMA VARCHAR2 IN
Q_NAME VARCHAR2 IN
PROCEDURE DBMS_AQADM_SYS.VERIFY_QUEUE_TYPES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC_QUEUE_NAME VARCHAR2 IN
DEST_QUEUE_NAME VARCHAR2 IN
DESTINATION VARCHAR2 IN
TRANSFORMATION VARCHAR2 IN
QUEUE_EXISTS BOOLEAN IN
GET_NRP BOOLEAN IN
RC BINARY_INTEGER OUT
PROCEDURE DBMS_AQADM_SYS.WRITE_TRACE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MESSAGE VARCHAR2 IN
EVENT BINARY_INTEGER IN DEFAULT
EVENT_LEVEL BINARY_INTEGER IN DEFAULT
TIME_INFO BOOLEAN IN DEFAULT
 |
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
|
|
