Oracle DBMS_AQ_INV
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
AUTHID CURRENT_USER
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 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx