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 will be available on generic Linux platforms in January and soon on AIX and Windows

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