Oracle | DBMS_PRVTSQIS

Oracle DBMS_PRVTSQIS 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 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_AQINT_LIB	DBMS_SQADM_LIB
AQ$_DEQUEUE_LOG_PARTITION_MAP	DBMS_AQMIGTOOL_SYS	DBMS_SQADM_SYSCALLS
DBMS_AQADM_INV	DBMS_ASSERT	DBMS_SQL
DBMS_AQADM_SYS	DBMS_LOGSTDBY	DBMS_SYSTEM
DBMS_AQADM_SYSCALLS	DBMS_PRVTAQIS	DBMS_SYS_ERROR
DBMS_AQADM_VAR	DBMS_PRVTSQDS	DUAL

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	CHILD_SUB_EXISTS	NON_DURABLE_SUB_EXISTS
ADD_CHILD_SUBSCRIBER	CREATE_SUBSCRIBER_VIEW	REMOVE_ALL_CHILD
ADD_DURABLE_SUB	CRTDRPDSUBKGLSCQ	REMOVE_CHILD
ADD_NON_DURABLE_SUB	DROP_SUBSCRIBER_VIEW	REMOVE_SUBSCRIBER_12G
ADD_SUBSCRIBER_12G	DURABLE_SUB_EXISTS	SUBMATCH
AGENT_EXISTS	GETDURSUBMETADATA	SUBSCRIPTION_EXISTS
ALTER_SUBSCRIBER_12G

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

      exec 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

      exec 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