Oracle | DBMS_AQ

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

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