Oracle DBMS_PRVTAQIS
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 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
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