Oracle DBMS_PRVTAQIS
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 Advanced Queuing Utilities
AUTHID DEFINER
Dependencies
AQ$_AGENT DBMS_AQINT_LIB EXPDEPACT$
AQ$_QUEUES DBMS_AQJMS EXPDEPOBJ$
AQ$_QUEUE_TABLES DBMS_AQ_IMPORT_INTERNAL OBJ$
AQ$_SUBSCRIBERS DBMS_AQ_IMPORT_INTERNAL_DR PLITBLM
DBA_EVALUATION_CONTEXTS DBMS_AQ_SYS_EXP_INTERNAL PROPS$
DBA_INDEXES DBMS_AQ_SYS_IMP_INTERNAL RE$TABLE_ALIAS
DBA_OBJECTS DBMS_ASSERT RE$TABLE_ALIAS_LIST
DBA_RULE_SETS DBMS_LOGSTDBY RE$VARIABLE_TYPE
DBA_RULE_SET_RULES DBMS_PRVTAQIM RE$VARIABLE_TYPE_LIST
DBA_TABLES DBMS_PRVTSQIS RE$VARIABLE_VALUE
DBMS_AQADM DBMS_RULE_ADM RULE_MAP$
DBMS_AQADM_INV DBMS_SQL RULE_SET$
DBMS_AQADM_LIB DBMS_SYSTEM TAB$
DBMS_AQADM_SYS DBMS_SYS_ERROR USER$
DBMS_AQADM_SYSCALLS DBMS_UTILITY V$INSTANCE
DBMS_AQADM_VAR EXPACT$  
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmsaqds.plb
{ORACLE_HOME}/rdbms/admin/prvtaqis.plb
Subprograms
ADD_ADDRESS CREATE_SUBSCRIBER_TABLE FIX_SUBSCRIBER_TABLES_2424746
ADD_PROXY CREATE_SUBSCRIBER_VIEW INSERT_DUMMY_ROW
ADD_QUEUE_RULE DELETE_REMOVED_SUBSCRIBERS PATCH_PRE92_SUBSCRIBERS
ADD_RCPT DOWNGRADE_92_90 PATCH_RSUB_EXPDEP
ADD_RS_EXPDEP DOWNGRADE_QT_RULESUB_MSGS PATCH_RULESET_COLUMN
ADD_SUBSCRIBER DOWNGRADE_RULESUB_MSGS PATCH_SUBTAB_COLUMN
ADD_SUBSCRIBER_RULE DOWNGRADE_RULE_FRM10I PATCH_SUBTAB_OPERATIONS
ADD_TO_EXPDEP DOWNGRADE_SUBSCRIBERS POPULATE_SYS_SUBSCRIBER_TABLE
AGENTID DROP_QTAB_EVCTX QTAB_ADD_BUFFER
AGENT_EXISTS DROP_QUEUE_DEFAULT_RULESETS QUEUE_SUBSCRIBERS
ALTER_SUBSCRIBER DROP_QUEUE_NPRS RULE_SUBSCRIBERS_EXIST
AQ_PATCH_SUBSCRIBER_TABLE DROP_QUEUE_RULE SUBID_REPLICATE
CANON_SUBTAB_RSNAME DROP_QUEUE_RULE_SET SUBID_REPLICATE_INT
CHECK_AGENT_NAME DROP_QUEUE_SUBSCRIBERS UPDATE_SUBTAB_ADDR
CHK_SUB_ADD_BUFFER DROP_RULES_VIEW UPGRADE_90_92
CREATE_90_RULES_VIEW DROP_SUBSCRIBER UPGRADE_QT_RULESUB_MSGS
CREATE_QTAB_EVCTX DROP_SUBSCRIBER_SEQUENCE UPGRADE_RULESUB_MSGS
CREATE_QUEUE_RULE_SET DROP_SUBSCRIBER_TABLE UPGRADE_RULE_10I
CREATE_RULES_VIEW DROP_SUBSCRIBER_VIEW UPGRADE_SUBSCRIBERS
CREATE_SUBSCRIBER_SEQUENCE    
 
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
 
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;
BEGIN dbms_prvtaqis.downgrade_rulesub_msgs; END;
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 5611
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 5443
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 5619
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 5619
ORA-06512: at line 1
 
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AQ
DBMS_AQADM
DBMS_PRVTAQIM
DBMS_PRVTAQIP
DBMS_SCHEDULER
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-2022 Daniel A. Morgan All Rights Reserved
  DBSecWorx