Oracle | DBMS_PRVTAQIS

Oracle DBMS_PRVTAQIS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Advanced Queuing Utilities

AUTHID DEFINER

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_PRVTAQIS' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_PRVTAQIS' ORDER BY 1;

Returns 51 objects

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the OGG_APPLY_PROCREP role.

Source {ORACLE_HOME}/rdbms/admin/dbmsaqds.plb
{ORACLE_HOME}/rdbms/admin/prvtaqis.plb

Subprograms

ADD_ADDRESS	CREATE_SUBSCRIBER_SEQUENCE	FIX_SUBSCRIBER_TABLES_2424746
ADD_PROXY	CREATE_SUBSCRIBER_TABLE	INSERT_DUMMY_ROW
ADD_QUEUE_RULE	CREATE_SUBSCRIBER_VIEW	PATCH_PRE92_SUBSCRIBERS
ADD_RCPT	DELETE_REMOVED_SUBSCRIBERS	PATCH_RSUB_EXPDEP
ADD_RS_EXPDEP	DOWNGRADE_92_90	PATCH_RULESET_COLUMN
ADD_SUBSCRIBER	DOWNGRADE_QT_RULESUB_MSGS	PATCH_SUBTAB_COLUMN
ADD_SUBSCRIBER_RULE	DOWNGRADE_RULESUB_MSGS	PATCH_SUBTAB_OPERATIONS
ADD_TO_EXPDEP	DOWNGRADE_RULE_FRM10I	POPULATE_SYS_SUBSCRIBER_TABLE
AGENTID	DOWNGRADE_SUBSCRIBERS	QTAB_ADD_BUFFER
AGENT_EXISTS	DROP_QTAB_EVCTX	QUEUE_SUBSCRIBERS
ALTER_SUBSCRIBER	DROP_QUEUE_DEFAULT_RULESETS	RULE_SUBSCRIBERS_EXIST
AQ_PATCH_SUBSCRIBER_TABLE	DROP_QUEUE_NPRS	SUBID_REPLICATE
CANON_SUBTAB_RSNAME	DROP_QUEUE_RULE	SUBID_REPLICATE_INT
CHECK_AGENT_NAME	DROP_QUEUE_RULE_SET	UPDATE_SUBTAB_ADDR
CHECK_RULE	DROP_QUEUE_SUBSCRIBERS	UPGRADE_90_92
CHK_SUB_ADD_BUFFER	DROP_RULES_VIEW	UPGRADE_QT_RULESUB_MSGS
CREATE_90_RULES_VIEW	DROP_SUBSCRIBER	UPGRADE_RULESUB_MSGS
CREATE_QTAB_EVCTX	DROP_SUBSCRIBER_SEQUENCE	UPGRADE_RULE_10I
CREATE_QUEUE_RULE_SET	DROP_SUBSCRIBER_TABLE	UPGRADE_SUBSCRIBERS
CREATE_RULES_VIEW	DROP_SUBSCRIBER_VIEW

ADD_ADDRESS

Undocumented dbms_prvtaqis.add_address( q_schema IN VARCHAR2, q_name IN VARCHAR2, qt_name IN VARCHAR2, agent_address IN VARCHAR2, agent_protocol IN NUMBER, addrid IN OUT NUMBER);

TBD

ADD_PROXY

Undocumented dbms_prvtaqis.add_proxy( q_schema IN VARCHAR2, q_name IN VARCHAR2, qt_name IN VARCHAR2, address IN VARCHAR2, protocol IN NUMBER, proxyno IN OUT NUMBER, queueid IN NUMBER, qprop IN NUMBER, sprop IN NUMBER);

TBD

ADD_QUEUE_RULE

Undocumented dbms_prvtaqis.add_queue_rule( rs_name IN VARCHAR2, qt_schema IN VARCHAR2, qt_name IN VARCHAR2, r_schema IN VARCHAR2, r_name IN VARCHAR2, r_cond IN VARCHAR2);

TBD

ADD_RCPT

Undocumented dbms_prvtaqis.add_rcpt( q_schema IN VARCHAR2, q_name IN VARCHAR2, qt_name IN VARCHAR2, agent_name IN VARCHAR2, agent_address IN VARCHAR2, rcptid IN OUT NUMBER);

TBD

ADD_RS_EXPDEP

Undocumented dbms_prvtaqis.add_rs_expdep( ruleset_name IN VARCHAR2, qtab_obj IN NUMBER);

TBD

ADD_SUBSCRIBER

Undocumented dbms_prvtaqis.add_subscriber( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub IN sys.aq$agent, rule IN VARCHAR2, trans_owner IN VARCHAR2, trans_name IN VARCHAR2, ruleset_owner IN VARCHAR2, ruleset_name IN VARCHAR2, negative_ruleset_owner IN VARCHAR2, negative_ruleset_name IN VARCHAR2, properties IN NUMBER, client_session_guid IN VARCHAR2, security_check IN BOOLEAN, instno IN NUMBER, current_user IN VARCHAR2);

TBD

ADD_SUBSCRIBER_RULE

Undocumented dbms_prvtaqis.add_subscriber_rule( q_schema IN VARCHAR2, q_name IN VARCHAR2, qt_name IN VARCHAR2, rule_name IN VARCHAR2, rule IN VARCHAR2, default_rset IN VARCHAR2);

TBD

ADD_TO_EXPDEP

Undocumented dbms_prvtaqis.add_to_expdep( dep_obj IN NUMBER, par_obj IN NUMBER);

TBD

AGENTID

Undocumented dbms_prvtaqis.agentid( q_schema IN VARCHAR2, qt_name IN VARCHAR2) RETURN NUMBER;

TBD

AGENT_EXISTS

Undocumented dbms_prvtaqis.agent_exists( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub IN sys.aq$agent, in_subscr_type IN NUMBER, subscr_type IN OUT NUMBER, rule_name IN OUT VARCHAR2, trans_name IN OUT VARCHAR2, ruleset IN OUT VARCHAR2, negative_ruleset IN OUT VARCHAR2, in_sub_id IN NUMBER) RETURN NUMBER;

TBD

ALTER_SUBSCRIBER

Undocumented dbms_prvtaqis.alter_subscriber( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub IN sys.aq$_agent, rule IN VARCHAR2, trans_owner IN VARCHAR2, trans_name IN VARCHAR2, ruleset_owner IN VARCHAR2, ruleset_name IN VARCHAR2, negative_ruleset_owner IN VARCHAR2, negative_ruleset_name IN VARCHAR2, compatible IN VARCHAR2, current_user IN VARCHAR2);

TBD

AQ_PATCH_SUBSCRIBER_TABLE

Undocumented dbms_prvtaqis.aq_patch_subscriber_table( schema IN VARCHAR2, st_name IN VARCHAR2, qt_name IN VARCHAR2);

TBD

CANON_SUBTAB_RSNAME

Undocumented dbms_prvtaqis.canon_subtab_rsname( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, st_name IN VARCHAR2, qtable_flags IN OUT NUMBER);

TBD

CHECK_AGENT_NAME

Undocumented dbms_prvtaqis.check_agent_name( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub IN sys.aq$agent) RETURN BOOLEAN;

TBD

CHECK_RULE (new 23ai)

Undocumented dbms_prvtaqis.check_rule( rule_name IN VARCHAR2, in_rule_cond IN CLOB) RETURN NUMBER;

TBD

CHK_SUB_ADD_BUFFER

Undocumented dbms_prvtaqis.chk_sub_add_buffer( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, q_name IN VARCHAR2);

TBD

CREATE_90_RULES_VIEW

Undocumented dbms_prvtaqis.create_90_rules_view( qt_schema IN VARCHAR2, qt_name IN VARCHAR2);

TBD

CREATE_QTAB_EVCTX

Undocumented dbms_prvtaqis.create_qtab_evctx( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

CREATE_QUEUE_RULE_SET

Undocumented dbms_prvtaqis.create_queue_rule_set( rs_name IN VARCHAR2, qt_schema IN VARCHAR2, qt_name IN VARCHAR2);

TBD

CREATE_RULES_VIEW

Undocumented dbms_prvtaqis.create_rules_view( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, replace_vw IN BOOLEAN);

TBD

CREATE_SUBSCRIBER_SEQUENCE

Undocumented dbms_prvtaqis.create_subscriber_sequence( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, start_value IN NUMBER);

TBD

CREATE_SUBSCRIBER_TABLE

Undocumented dbms_prvtaqis.create_subscriber_table( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, commit_time IN BOOLEAN);

TBD

CREATE_SUBSCRIBER_VIEW

Undocumented dbms_prvtaqis.create_subscriber_view( qt_schema IN VARCHAR2, qt_name IN VARCHAR2);

TBD

DELETE_REMOVED_SUBSCRIBERS

Undocumented dbms_prvtaqis.delete_removed_subscribers( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, q_name IN VARCHAR2);

TBD

DOWNGRADE_92_90

Undocumented dbms_prvtaqis.downgrade_92_90( qt_schema IN VARCHAR2, qt_name IN VARCHAR2);

TBD

DOWNGRADE_QT_RULESUB_MSGS

Undocumented dbms_prvtaqis.downgrade_qt_rulesub_msgs( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

DOWNGRADE_RULESUB_MSGS

Undocumented dbms_prvtaqis.downgrade_rulesub_msgs;

exec dbms_prvtaqis.downgrade_rulesub_msgs;

      *

      ERROR at line 1:

      ORA-01403: no data found

DOWNGRADE_RULE_FRM10I

Undocumented dbms_prvtaqis.downgrade_rule_frm10i( qt_schema IN VARCHAR2, qt_name IN VARCHAR2);

TBD

DOWNGRADE_SUBSCRIBERS

Undocumented dbms_prvtaqis.downgrade_subscribers( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

DROP_QTAB_EVCTX

Undocumented dbms_prvtaqis.drop_qtab_evctx( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, expdp_only IN BOOLEAN, force IN BOOLEAN);

TBD

DROP_QUEUE_DEFAULT_RULESETS

Undocumented dbms_prvtaqis.drop_queue_default_rulesets( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, q_name IN VARCHAR2);

TBD

DROP_QUEUE_NPRS

Undocumented dbms_prvtaqis.drop_queue_nprs( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, q_name IN VARCHAR2);

TBD

DROP_QUEUE_RULE

Undocumented dbms_prvtaqis.drop_queue_rule( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, r_schema IN VARCHAR2, r_name IN VARCHAR2);

TBD

DROP_QUEUE_RULE_SET

Undocumented dbms_prvtaqis.drop_queue_rule_set( rs_name IN VARCHAR2, qt_schema IN VARCHAR2, qt_name IN VARCHAR2, drop_rules IN BOOLEAN);

TBD

DROP_QUEUE_SUBSCRIBERS

Undocumented dbms_prvtaqis.drop_queue_subscribers( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, q_name IN VARCHAR2);

TBD

DROP_RULES_VIEW

Undocumented dbms_prvtaqis.drop_rules_view( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

DROP_SUBSCRIBER

Undocumented dbms_prvtaqis.drop_subscriber( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub IN sys.aq$agnet, proxyid IN NUMBER, current_user IN VARCHAR2);

TBD

DROP_SUBSCRIBER_SEQUENCE

Undocumented dbms_prvtaqis.drop_subscriber_sequence( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

DROP_SUBSCRIBER_TABLE

Undocumented dbms_prvtaqis.drop_subscriber_table( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

DROP_SUBSCRIBER_VIEW

Undocumented dbms_prvtaqis.drop_subscriber_view( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

FIX_SUBSCRIBER_TABLES_2424746

Undocumented dbms_prvtaqis.fix_subscriber_tables_2424746;

exec dbms_prvtaqis.fix_subscriber_tables_2424746;

      

      PL/SQL procedure successfully completed.

INSERT_DUMMY_ROW

Undocumented dbms_prvtaqis.insert_dummy_row( qt_schema IN VARCHAR2, qt_name IN VARCHAR2);

TBD

PATCH_PRE92_SUBSCRIBERS

Undocumented dbms_prvtaqis.patch_pre92_subscribers( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, st_name IN VARCHAR2);

TBD

PATCH_RSUB_EXPDEP

Undocumented dbms_prvtaqis.patch_rsub_expdep( schema IN VARCHAR2, queue_table IN VARCHAR2, queue IN VARCHAR2, qtable_flags IN NUMBER);

TBD

PATCH_RULESET_COLUMN

Undocumented dbms_prvtaqis.patch_ruleset_column( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, st_name IN VARCHAR2, qt_pre92 OUT BOOLEAN, qtable_flags IN OUT NUMBER);

TBD

PATCH_SUBTAB_COLUMN

Undocumented dbms_prvtaqis.patch_subtab_column( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, st_name IN VARCHAR2, column_name IN VARCHAR2);

TBD

PATCH_SUBTAB_OPERATIONS

Undocumented dbms_prvtaqis.patch_subtab_operations( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, st_name IN VARCHAR2);

TBD

POPULATE_SYS_SUBSCRIBER_TABLE

Undocumented dbms_prvtaqis.populate_sys_subscriber_table( schema IN VARCHAR2, queue_table IN VARCHAR2, queue IN VARCHAR2);

TBD

QTAB_ADD_BUFFER

Undocumented dbms_prvtaqis.qtab_add_buffer( qt_schema IN VARCHAR2, qt_name IN VARCHAR2);

TBD

QUEUE_SUBSCRIBERS

Undocumented dbms_prvtaqis.queue_subscribers( q_schema IN VARCHAR2, q_name IN VARCHAR2) RETURN sys.dbms_aqadm.aq$_subscriber_list_t;

TBD

RULE_SUBSCRIBERS_EXIST

Undocumented dbms_prvtaqis.rule_subscribers_exist( qt_schema IN VARCHAR2, qt_name IN VARCHAR2) RETURN BOOLEAN;

TBD

SUBID_REPLICATE

Undocumented dbms_prvtaqis.subid_replicate( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub IN sys.aq$agent, qt_name IN VARCHAR2, subid IN NUMBER, subtab_name IN VARCHAR2, sub_flag IN NUMBER, proxyid IN NUMBER, proxy_addr IN VARCHAR2, proxy_prot IN NUMBER, proxy_flag IN NUMBER, pexist IN BOOLEAN, subscr_type IN NUMBER, addrid IN NUMBER, rule IN VARCHAR2, ruleset_owner IN VARCHAR2, ruleset_name IN VARCHAR2, trans_owner IN VARCHAR2, trans_name IN VARCHAR2, negative_ruleset_owner IN VARCHAR2, negative_ruleset_name IN VARCHAR2, properties IN NUMBER, client_session_guid IN VARCHAR2, security_check IN BOOLEAN, instno IN NUMBER, current_user IN VARCHAR2);

TBD

SUBID_REPLICATE_INT

Undocumented dbms_prvtaqis.subid_replicate_int( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub IN sys.aq$agent, qt_name IN VARCHAR2, subid IN NUMBER, subtab_name IN VARCHAR2, sub_flag IN NUMBER, proxyid IN NUMBER, proxy_addr IN VARCHAR2, proxy_prot IN NUMBER, proxy_flag IN NUMBER, pexist IN BOOLEAN, subscr_type IN NUMBER, addrid IN NUMBER, rule IN VARCHAR2, ruleset_owner IN VARCHAR2, ruleset_name IN VARCHAR2, trans_owner IN VARCHAR2, trans_name IN VARCHAR2, negative_ruleset_owner IN VARCHAR2, negative_ruleset_name IN VARCHAR2, properties IN NUMBER, client_session_guid IN VARCHAR2, security_check IN BOOLEAN, instno IN NUMBER, current_user IN VARCHAR2);

TBD

UPDATE_SUBTAB_ADDR

Undocumented dbms_prvtaqis.update_subtab_addr( schema IN VARCHAR2, st_name IN VARCHAR2);

TBD

UPGRADE_90_92

Undocumented dbms_prvtaqis.upgrade_90_92( qt_schema IN VARCHAR2, qt_name IN VARCHAR2);

TBD

UPGRADE_QT_RULESUB_MSGS

Undocumented dbms_prvtaqis.upgrade_qt_rulesub_msgs( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

UPGRADE_RULESUB_MSGS

Undocumented dbms_prvtaqis.upgrade_rulesub_msgs;

exec dbms_prvtaqis.upgrade_rulesub_msgs;

      

      PL/SQL procedure successfully completed.

UPGRADE_RULE_10I

Undocumented dbms_prvtaqis.upgrade_rule_10i( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, q_name IN VARCHAR2, chk_subtab IN BOOLEAN);

TBD

UPGRADE_SUBSCRIBERS

Undocumented dbms_prvtaqis.upgrade_subscribers( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD