Oracle DBMS_PRVTSQIS
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 CURRENT_USER
Constants
Name Data Type Value
General
KWSA_SUBKGL_SCQ_CRT BINARY_INTEGER 0
KWSA_SUBKGL_SCQ_DRP BINARY_INTEGER 1
Dependencies
AQ$_AGENT DBMS_ASSERT DBMS_SQADM_SYSCALLS
AQ$_DEQUEUE_LOG_PARTITION_MAP DBMS_LOGSTDBY DBMS_SQL
DBMS_AQADM_INV DBMS_PRVTAQIS DBMS_SYSTEM
DBMS_AQADM_SYS DBMS_PRVTSQDS DBMS_SYS_ERROR
DBMS_AQADM_SYSCALLS DBMS_SQADM_LIB DUAL
DBMS_AQADM_VAR    
Documented No
First Available 12.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmssqds.plb
{ORACLE_HOME}/rdbms/admin/prvtsqis.plb
Subprograms
 
ADD_CHILD_SUB
Undocumented dbm_prvtsqis.add_child_sub(
qschema  IN VARCHAR2,
qname    IN VARCHAR2,
sub_name IN VARCHAR2,
qid      IN NUMBER,
qobjn    IN NUMBER,
parent   IN VARCHAR2);
TBD
 
ADD_CHILD_SUBSCRIBER
Undocumented dbm_prvtsqis.add_child_subscriber(
qschema            IN VARCHAR2,
qname              IN VARCHAR2,
subscriber         IN sys.aq$_agent,
parent             IN sys.aq$_agent,
name_canonicalized IN BOOLEAN);
TBD
 
ADD_DURABLE_SUB
Undocumented dbm_prvtsqis.add_durable_sub(
qschema       IN VARCHAR2,
qname         IN VARCHAR2,
sub_name      IN VARCHAR2,
sub_addr      IN VARCHAR2,
sub_prot      IN NUMBER,
flags         IN NUMBER,
rulecond      IN VARCHAR2,
transschema   IN VARCHAR2,
transname     IN VARCHAR2,
add_jms_entry IN BOOLEAN,
subid         IN NUMBER,
sprop         IN NUMBER,
createdate    IN TIMESTAMP WITH TIME ZONE);
TBD
 
ADD_NON_DURABLE_SUB
Undocumented dbm_prvtsqis.add_non_durable_sub(
qschema       IN VARCHAR2,
qname         IN VARCHAR2,
sub_name      IN VARCHAR2,
sub_addr      IN VARCHAR2,
sub_prot      IN NUMBER,
flags         IN NUMBER,
rule_cond     IN VARCHAR2,
transschema   IN VARCHAR2,
transname     IN VARCHAR2,
session_guid  IN NUMBER,
add_jms_entry IN BOOLEAN,
qid           IN NUMBER,
qobjn         IN NUMBER);
TBD
 
ADD_SUBSCRIBER_12G
Undocumented dbm_prvtsqis.add_subscriber_12g(
qschema             IN VARCHAR2,
qname               IN VARCHAR2,
subscriber          IN sys.aq$_agent,
rule                IN VARCHAR2,
security_check      IN BOOLEAN,
in_recursive_txn    IN BOOLEAN,
add_jms_entry       IN BOOLEAN,
transformation      IN VARCHAR2,
properties          IN NUMBER,
name_canonicalized  IN BOOLEAN,
queue_to_queue      IN BOOLEAN,
client_session_guid IN VARCHAR2,
instno              IN NUMBER,
current_user        IN VARCHAR2);
TBD
 
AGENT_EXISTS
Undocumented dbm_prvtsqis.agent_exists(
q_schema         IN     VARCHAR2,
q_name           IN     VARCHAR2,
q_id             IN     NUMBER,
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_12G
Undocumented dbm_prvtsqis.alter_subscriber_12g(
qschema            IN VARCHAR2,
qname              IN VARCHAR2,
subscriber         IN sys.aq$_agent,
rule               IN VARCHAR2,
security_check     IN BOOLEAN,
in_recursive_txn   IN BOOLEAN,
transformation     IN VARCHAR2,
compatible         IN VARCHAR2,
name_canonicalized IN BOOLEAN,
current_user       IN VARCHAR2);
TBD
 
CHILD_SUB_EXISTS
Undocumented dbm_prvtsqis.child_sub_exists(
qschema  IN VARCHAR2,
qname    IN VARCHAR2,
sub_name IN VARCHAR2,
par_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
CREATE_SUBSCRIBER_VIEW
Undocumented dbm_prvtsqis.create_subscriber_view(
qtschema IN VARCHAR2,
qtname   IN VARCHAR2);
TBD
 
CRTDRPDSUBKGLSCQ
Undocumented dbm_prvtsqis.crtDrpSubKGLSCQ(
q_schema IN VARCHAR2,
q_name   IN VARCHAR2,
qt_flags IN NUMBER,
action   IN BINARY_INTEGER);
-- from $ORACLE_HOME/rdbms/admin/a19.sql
sys.dbms_prvtsqis.CrtDrpDsubKglScq(usern, dql_alter_rec.name, dql_alter_rec.flags, sys.dbms_prvtsqis.KWSA_SUBKGL_SCQ_CRT);

-- from $ORACLE_HOME/rdbms/admin/f19.sql
sys.dbms_prvtsqis.CrtDrpDsubKglScq(usern, dql_alter_rec.name, dql_alter_rec.flags, sys.dbms_prvtsqis.KWSA_SUBKGL_SCQ_DRP);
 
DROP_SUBSCRIBER_VIEW
Undocumented dbm_prvtsqis.drop_subscriber_view(
qtschema         IN VARCHAR2,
qtname           IN VARCHAR2,
ignore_ddl_error IN BOOLEAN);
TBD
 
DURABLE_SUB_EXISTS
Undocumented dbm_prvtsqis.durable_sub_exists(
qschema  IN VARCHAR2,
qname    IN VARCHAR2,
sub_name IN VARCHAR2,
sub_addr IN VARCHAR2,
sub_prot IN NUMBER)
RETURN BOOLEAN;
TBD
 
GETDURSUBMETADATA
Undocumented dbm_prvtsqis.getDurSubMetadata(
qid         IN     NUMBER,
subname     IN     VARCHAR2,
subaddr     IN     VARCHAR2,
subprot     IN     NUMBER,
subid          OUT NUMBER,
subtype     IN OUT NUMBER,
rulename       OUT VARCHAR2,
transschema    OUT VARCHAR2,
transname      OUT VARCHAR2)
RETURN BOOLEAN;
TBD
 
NON_DURABLE_SUB_EXISTS
Undocumented dbm_prvtsqis.non_durable_sub_exists(
qschema IN VARCHAR2,
qname   IN VARCHAR2,
subname IN VARCHAR2,
subaddr IN VARCHAR2,
subprot IN NUMBER)
RETURN BOOLEAN;
TBD
 
REMOVE_ALL_CHILD
Undocumented dbm_prvtsqis.remove_all_child(
qschema        IN VARCHAR2,
qname          IN VARCHAR2,
subscriber     IN sys.aq$_agent,
is_background  IN BOOLEAN,
is_parent_drop IN BOOLEAN);
TBD
 
REMOVE_CHILD
Undocumented dbm_prvtsqis.remove_child(
qschema        IN VARCHAR2,
qname          IN VARCHAR2,
subscriber     IN sys.aq$_agent,
parent         IN sys.aq$_agent,
name_canon     IN BOOLEAN,
is_background  IN BOOLEAN,
is_parent_drop IN BOOLEAN);
TBD
 
REMOVE_SUBSCRIBER_12G
Undocumented dbm_prvtsqis.remove_subscriber_12g(
qschema          IN VARCHAR2,
qname            IN VARCHAR2,
subscriber       IN sys.aq$_agent,
security_check   IN BOOLEAN,
in_recursive_txn IN BOOLEAN,
name_canon       IN BOOLEAN,
current_user     IN VARCHAR2);
TBD
 
SUBMATCH
Undocumented dbm_prvtsqis.submatch(
qschema     IN  VARCHAR2,
rule        IN  VARCHAR2,
subrl       IN  VARCHAR2,
transsch    IN  VARCHAR2,
transnm     IN  VARCHAR2,
subtranssch IN  VARCHAR2,
subtransnm  IN  VARCHAR2,
rlmatch     OUT BOOLEAN,
transmatch  OUT BOOLEAN);
TBD
SUBSCRIPTION_EXISTS
Undocumented dbm_prvtsqis.subscription_exists(
qschema  IN VARCHAR2,
qname    IN VARCHAR2,
sub_name IN VARCHAR2,
sub_addr IN VARCHAR2,
sub_prot IN NUMBER)
RETURN BOOLEAN;
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AQADM
DBMS_AQADM_INV
DBMS_AQADM_VAR
DBMS_AQELM
DBMS_AQIN
DBMS_AQ_BQVIEW
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_INV
DBMS_AQ_SUB
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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx