Oracle | DBMS_AQ

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	PURGE_BUFFERED_SCQ_TABLE	PURGE_ELIGIBLE_SUB_MSGS_TXN
CREATE_PROC_BUFFERED_SCQ	PURGE_ELIGIBLE_RCPT_MESSAGES	PURGE_PERSISTENT_MCQ_TABLE
INTERNAL_PURGE_QUEUE_TABLE	PURGE_ELIGIBLE_RCPT_MSGS_TXN	PURGE_PERSISTENT_SCQ_TABLE
PURGE_BUFFERED_MCQ_TABLE	PURGE_ELIGIBLE_SUB_MESSAGES	PURGE_PROCEDURE_NAME

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.

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx