Oracle DBMS_AQ_INV
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose Undocumented
AUTHID CURRENT_USER
Data Types CHAIN_NO_LIST
ENQ_TIME_LIST
LOCAL_ORDER_NO_LIST
MSG_ID_LIST
MSG_PRTY_LIST
MSG_STATE_LIST
NAME_LIST
QUEUE#_LIST
STEP_NO_LIST
SUB_ID_LIST
Dependencies
AQ$_BND DBMS_ASSERT PLITBLM
AQ$_BND_ARRAY DBMS_RULE RE$TABLE_ALIAS
DBMS_AQ DUAL RE$TABLE_ALIAS_LIST
DBMS_AQADM_SYS    
Documented No
Exceptions
Error Code Reason
   
   
   
First Available Not known
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtaqiu.plb
Subprograms
 
CREATE_PROC_BUFFERED_MCQ
Undocumented dbms_aq_inv.create_proc_buffered_mcq(
proc_name IN VARCHAR2,
qt_schema IN VARCHAR2,
qt_name   IN VARCHAR2,
invoker   IN VARCHAR2);
TBD
 
CREATE_PROC_BUFFERED_SCQ
Undocumented dbms_aq_inv.create_proc_buffered_scq(
proc_name IN VARCHAR2,
qt_schema IN VARCHAR2,
qt_name   IN VARCHAR2,
invoker   IN VARCHAR2);
TBD
 
INTERNAL_PURGE_QUEUE_TABLE
Undocumented dbms_aq_inv.internal_purge_queue_table(
qt_schema       IN VARCHAR2,
qt_name         IN VARCHAR2,
qt_flags        IN BINARY_INTEGER,
tobjno          IN NUMBER,
qt_sort_cols    IN BINARY_INTEGER,
delivery_mode   IN BINARY_INTEGER,
purge_condition IN VARCHAR2,
invoker         IN VARCHAR2,
ifjms           IN BOOLEAN);
TBD
 
PURGE_BUFFERED_MCQ_TABLE
Undocumented dbms_aq_inv.purge_buffered_mcq_table(
qt_schema       IN VARCHAR2,
qt_name         IN VARCHAR2,
qt_objno        IN NUMBER,
qt_flags        IN NUMBER,
purge_condition IN VARCHAR2,
invoker         IN VARCHAR2);
TBD
 
PURGE_BUFFERED_SCQ_TABLE
Undocumented dbms_aq_inv.purge_buffered_scq_table(
qt_schema       IN VARCHAR2,
qt_name         IN VARCHAR2,
qt_objno        IN VARCHAR2,
purge_condition IN VARCHAR2,
invoker         IN VARCHAR2);
TBD
 
PURGE_ELIGIBLE_RCPT_MESSAGES
Undocumented dbms_aq_inv.purge_eligible_rcpt_messages(
qt_schema          IN VARCHAR2,
qt_name            IN VARCHAR2,
name_arr           IN sys.dbms_aq_inv.name_list,
que_num_arr        IN sys.dbms_aq_inv.queue#_list,
enq_time_arr       IN sys.dbms_aq_inv.enq_time_list,
step_no_arr        IN sys.dbms_aq_inv.step_no_list,
msg_prty_arr       IN sys.dbms_aq_inv.msg_prty_list,
chain_no_arr       IN sys.dbms_aq_inv.chain_no_list,
local_order_no_arr IN sys.dbms_aq_inv.local_order_no_list,
msg_id_arr         IN sys.dbms_aq_inv.msg_id_list,
msg_state_arr      IN sys.dbms_aq_inv.msg_state_list,
qt_sort_cols       IN NUMBER,
ifallexpmsgs       IN BOOLEAN);
TBD
 
PURGE_ELIGIBLE_RCPT_MSGS_TXN
Undocumented dbms_aq_inv.purge_eligible_rcpt_msgs_txn(
qt_schema          IN VARCHAR2,
qt_name            IN VARCHAR2,
name_arr           IN sys.dbms_aq_inv.name_list,
que_num_arr        IN sys.dbms_aq_inv.queue#_list,
enq_time_arr       IN sys.dbms_aq_inv.enq_time_list,
step_no_arr        IN sys.dbms_aq_inv.step_no_list,
msg_prty_arr       IN sys.dbms_aq_inv.msg_prty_list,
chain_no_arr       IN sys.dbms_aq_inv.chain_no_list,
local_order_no_arr IN sys.dbms_aq_inv.local_order_no_list,
msg_id_arr         IN sys.dbms_aq_inv.msg_id_list,
msg_state_arr      IN sys.dbms_aq_inv.msg_state_list,
qt_sort_cols       IN NUMBER,
ifallexpmsgs       IN BOOLEAN);
TBD
 
PURGE_ELIGIBLE_SUB_MESSAGES
Undocumented dbms_aq_inv.purge_eligible_sub_messages(
qt_schema          IN VARCHAR2,
qt_name            IN VARCHAR2,
sub_id_arr         IN sys.dbms_aq_inv.sub_id_list,
enq_time_arr       IN sys.dbms_aq_inv.enq_time_list,
step_no_arr        IN sys.dbms_aq_inv.step_no_list,
msg_prty_arr       IN sys.dbms_aq_inv.msg_prty_list,
chain_no_arr       IN sys.dbms_aq_inv.chain_no_list,
local_order_no_arr IN sys.dbms_aq_inv.local_order_no_list,
msg_id_arr         IN sys.dbms_aq_inv.msg_id_list,
msg_state_arr      IN sys.dbms_aq_inv.msg_state_list,
qt_sort_cols       IN NUMBER,
ifallexpmsgs       IN BOOLEAN);
TBD
 
PURGE_ELIGIBLE_SUB_MSGS_TXN
Undocumented dbms_aq_inv.purge_eligible_sub_msgs_txn(
qt_schema          IN VARCHAR2,
qt_name            IN VARCHAR2,
sub_id_arr         IN sys.dbms_aq_inv.sub_id_list,
enq_time_arr       IN sys.dbms_aq_inv.enq_time_list,
step_no_arr        IN sys.dbms_aq_inv.step_no_list,
msg_prty_arr       IN sys.dbms_aq_inv.msg_prty_list,
chain_no_arr       IN sys.dbms_aq_inv.chain_no_list,
local_order_no_arr IN sys.dbms_aq_inv.local_order_no_list,
msg_id_arr         IN sys.dbms_aq_inv.msg_id_list,
msg_state_arr      IN sys.dbms_aq_inv.msg_state_list,
qt_sort_cols       IN NUMBER,
ifallexpmsgs       IN BOOLEAN);
TBD
 
PURGE_PERSISTENT_MCQ_TABLE
Undocumented dbms_aq_inv.purge_persistent_mcq_table(
qt_schema       IN VARCHAR2,
qt_name         IN VARCHAR2,
purge_condition IN VARCHAR2,
qt_flags        IN NUMBER,
qt_sort_cols    IN NUMBER,
ifjms           IN BOOLEAN,
invoker         IN VARCHAR2);
TBD
 
PURGE_PERSISTENT_SCQ_TABLE
Undocumented dbms_aq_inv.purge_persistent_scq_table(
qt_schema       IN VARCHAR2,
qt_name         IN VARCHAR2,
qt_flags        IN BINARY_INTEGER,
purge_condition IN VARCHAR2,
invoker         IN VARCHAR2);
TBD
 
PURGE_PROCEDURE_NAME
Undocumented dbms_aq_inv.purge_procedure_name(
qt_objno IN NUMBER,
is_mcq   IN PL/SQL BOOLEAN)
RETURN VARCHAR2;
DECLARE
 retVal dbms_id;
BEGIN
  retVal := dbms_aq_inv.purge_procedure_name(42, FALSE);
  dbms_output.put_line(retVal);
END;
/
AQ$42BUF_SCQ_TABLE_PURGE

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AQ
DBMS_AQADM
DBMS_AQADM_INV
DBMS_AQADM_VAR
DBMS_AQELM
DBMS_AQIN
DBMS_AQ_BQVIEW
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_EXP_ZECURITY
DBMS_AQ_IMPORT_INTERNAL
DBMS_AQ_IMP_ZECURITY
DBMS_AQ_IND_MON
DBMS_AQ_SUB
DBMS_AQ_SYS_EXP_ACTIONS
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx