Oracle | DBMS_SQADM

Oracle DBMS_SQADM_SYSCALLS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Support for Automatic Diagnostic Repository (ADR)

AUTHID DEFINER

Dependencies

DBMS_AQINT_LIB

DBMS_PRVTSQIS

DBMS_SQADM_LIB

Documented No

First Available 12.1

Security Model Owned by SYS with

Source {ORACLE_HOME}/rdbms/admin/dbmssqds.plb

Subprograms

KWSA_3GL_ADDCSUB	KWSA_3GL_CRTDRPDSUBKGLSCQ	KWSA_3GL_LOCKDSUB
KWSA_3GL_ADDDSUB	KWSA_3GL_DRPCSUB	KWSA_3GL_LOCKDSUBN
KWSA_3GL_ALTERDSUB	KWSA_3GL_DRPDSUB

KWSA_3GL_ADDCSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_addCSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_id IN NUMBER, pos_bmap OUT NUMBER, create_time IN TIMESTAMP WITH TIME ZONE, flags OUT NUMBER, parent_id OUT NUMBER, parent IN VARCHAR2);

TBD

KWSA_3GL_ADDDSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_addDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_addr IN VARCHAR2, sub_prot IN NUMBER, sub_id IN NUMBER, pos_bmapP OUT NUMBER, rule_name IN VARCHAR2, trans_sch IN VARCHAR2, trans_name IN VARCHAR2, create_time IN TIMESTAMP WITH TIME ZONE, flags IN NUMBER);

TBD

KWSA_3GL_ALTERDSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_alterDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, rule_name IN VARCHAR2, trans_sch IN VARCHAR2, trans_name IN VARCHAR2, updrule IN BOOLEAN, updtrans IN BOOLEAN);

TBD

KWSA_3GL_CRTDRPDSUBKGLSCQ

Undocumented dbms_sqadm_syscalls.kwsa_3gl_crtDrpDSubKGLSCQ( q_schema IN VARCHAR2, q_name IN VARCHAR2, qt_flags IN NUMBER, action IN BINARY_INTEGER);

TBD

KWSA_3GL_DRPCSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_drpCSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_addr IN VARCHAR2, sub_prot IN NUMBER, sub_id IN NUMBER, qid IN NUMBER, par_name IN VARCHAR2);

TBD

KWSA_3GL_DRPDSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_drpDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_addr IN VARCHAR2, sub_prot IN NUMBER, sub_id IN NUMBER, qid IN NUMBER);

TBD

KWSA_3GL_LOCKDSUB

Undocumented dbms_sqadm_syscalls.dbms_sqadm_syscalls.kwsa_3GL_LockDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, operation IN VARCHAR2, flags IN BINARY_INTEGER);

TBD

KWSA_3GL_LOCKDSUBN

Undocumented dbms_sqadm_syscalls.kwsa_3gl_lockDSubn( q_schema IN VARCHAR2, q_name IN VARCHAR2, operation IN VARCHAR2, flags IN BINARY_INTEGER, sub_id IN NUMBER);

TBD