Oracle | DBMS_SQLCONTROL

Oracle DBMS_SQLCONTROL_INTERNAL 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 SQL Quarantine Internal Support Utilities

AUTHID DEFINER

Dependencies

DBMS_SMB	DBMS_SQLQ_INTERNAL	SQLOBJ$
DBMS_SQLCONTROL_LIB	DBMS_SYS_ERROR

Documented No

First Available 19c

Security Model Owned by SYS with no privileges granted

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

Subprograms

ALTER_OBJECT	DROP_OBJECT	OBJECT_EXISTS
CREATE_OBJECT	GET_OBJECT_NAME

ALTER_OBJECT

Undocumented

Overload 1 dbms_sqlcontrol_internal.alter_object( name IN VARCHAR2, type IN NUMBER, attribute_name IN VARCHAR2, attribute_value IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

Overload 2 dbms_sqlcontrol_internal.alter_object( signature IN NUMBER, type IN NUMBER, attribute_name IN VARCHAR2, attribute_value IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

CREATE_OBJECT

Undocumented dbms_sqlcontrol_internal.create_object( sql_text IN CLOB, hint_xml IN CLOB, type IN NUMBER, plan_id IN NUMBER, category IN VARCHAR2, description IN VARCHAR2, creator IN VARCHAR2, validate IN BOOLEAN, force_match IN BOOLEAN) RETURN VARCHAR2;

TBD

DROP_OBJECT

Undocumented

Overload 1 dbms_sqlcontrol_internal.drop_object( name IN VARCHAR2, type IN NUMBER) RETURN BINARY_INTEGER;

TBD

Overload 2 dbms_sqlcontrol_internal.drop_object( signature IN NUMBER, type IN NUMBER) RETURN BINARY_INTEGER;

TBD

GET_OBJECT_NAME

Undocumented dbms_sqlcontrol_internal.i_create_object( sql_text IN CLOB, hint_xml IN CLOB, type IN NUMBER, plan_id IN NUMBER, category IN VARCHAR2, description IN VARCHAR2, creator IN VARCHAR2, validate IN BOOLEAN, force_match IN BOOLEAN) RETURN VARCHAR2;

TBD

OBJECT_EXISTS (new 23ai)

Undocumented

Overload 1 dbms_sqlcontrol_internal.object_exists( signature IN NUMBER, type IN NUMBER) RETURN BOOLEAN;

TBD

Overload 2 dbms_sqlcontrol_internal.object_exists( name IN VARCHAR2, type IN NUMBER) RETURN BOOLEAN;

TBD