Oracle | DBMS_PRVTSQDS

Oracle DBMS_PRVTSQDS 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 Related Management Utilities

AUTHID CURRENT_USER

Dependencies

DBMS_AQADM_INV	DBMS_AQMIGTOOL_SYS	DBMS_RULE_ADM
DBMS_AQADM_SYS	DBMS_AQ_SYS_EXP_INTERNAL	DBMS_SYSTEM
DBMS_AQADM_SYSCALLS	DBMS_ASSERT	DBMS_SYS_ERROR
DBMS_AQINT_LIB	DBMS_PRVTSQIS	EXPDEPOBJ$

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/prvtsqds.plb

Subprograms

ADDQUERULE	CREATESQRULESET	DROP_RULE_SEQUENCE
ALTERSUBRULE	CREATETMT	GETNUMQUESAMERULE
CHECKANDDROPRULE	CREATE_RULE_SEQUENCE	GETOBJNUMBER
CHECKDUPLRULECOND	DROPQUERULE	GETQUEUERULESET
CREATEEXPIMPDEP	DROPTMT

ADDQUERULE

Undocumented dbms_prvtsqds.addQueRule( rsschema IN VARCHAR2, rsname IN VARCHAR2, qobjn IN NUMBER, qschema IN VARCHAR2, qname IN VARCHAR2, ruleschema IN VARCHAR2, rulename IN VARCHAR2, rulecond IN VARCHAR2);

TBD

ALTERSUBRULE

Undocumented dbms_prvtsqds.alterSubRule( ruleschema IN VARCHAR2, rulename IN VARCHAR2, rulecond IN VARCHAR2);

TBD

CHECKANDDROPRULE

Undocumented dbms_prvtsqds.checkAndDropRule( qschema IN VARCHAR2, qname IN VARCHAR2, qtobjn IN NUMBER, ruleschema IN VARCHAR2, rulename IN VARCHAR2);

TBD

CHECKDUPLRULECOND

Undocumented dbms_prvtsqds.checkDuplRuleCond( rsschema IN VARCHAR2, rsname IN VARCHAR2, rulecond IN VARCHAR2, rulename OUT VARCHAR2) RETURN BOOLEAN;

TBD

CREATEEXPIMPDEP

Undocumented dbms_prvtsqds.createExpImpDep( pobjnum IN NUMBER, depobjnum IN NUMBER);

TBD

CREATESQRULESET

Undocumented dbms_prvtsqds.createSqRuleSet( rsschema IN VARCHAR2, rsname IN VARCHAR2, qobjn IN NUMBER);

TBD

CREATETMT

Undocumented dbms_prvtsqds.createTmt( qschema IN VARCHAR2, qname IN VARCHAR2, qflags IN NUMBER, sortord IN NUMBER, storage IN VARCHAR2);

TBD

CREATE_RULE_SEQUENCE

Undocumented dbms_prvtsqds.create_rule_sequence( qschema IN VARCHAR2, qname IN VARCHAR2);

TBD

DROPQUERULE

Undocumented dbms_prvtsqds.dropQueRule( qtobjn IN NUMBER, rsschema IN VARCHAR2, rsname IN VARCHAR2, ruleschema IN VARCHAR2, rulename IN VARCHAR2);

TBD

DROPTMT

Undocumented dbms_prvtsqds.dropTmt( qschema IN VARCHAR2, qname IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

DROP_RULE_SEQUENCE

Undocumented dbms_prvtsqds.drop_rule_sequence( qschema IN VARCHAR2, qname IN VARCHAR2, ignoreerr IN BOOLEAN);

TBD

GETNUMQUESAMERULE

Undocumented dbms_prvtsqds.getNumQueSameRule( qschema IN VARCHAR2, qname IN VARCHAR2, rulename IN VARCHAR2) RETURN NUMBER;

TBD

GETOBJNUMBER

Undocumented dbms_prvtsqds.getObjNumber( schema IN VARCHAR2, name IN VARCHAR2, objtype IN NUMBER, objnum OUT NUMBER);

TBD

GETQUEUERULESET

Undocumented dbms_prvtsqds.getQueueRuleSet( qname IN VARCHAR2, rsname OUT VARCHAR2);

TBD