Oracle | DBMS_SQLCONTROL

Oracle DBMS_SQLCONTROL_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose SQL Quarantine Internal Support Utilities

AUTHID DEFINER

Dependencies

DBMS_SMB	DBMS_SQLQ_INTERNAL	SQLOBJ$
DBMS_SQLCONTROL_LIB	DBMS_SQLTUNE_UTIL0	SQLOBJ$

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	GET_OBJECT_NAME
CREATE_OBJECT	EXISTS_OBJECT

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

EXISTS_OBJECT

Undocumented

Overload 1 dbms_sqlcontrol_internal.exists_object( SQL_TEXT IN CLOB, type IN NUMBER, plan_id IN NUMBER, category IN VARCHAR2) RETURN BOOLEAN;

TBD

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

TBD

GET_OBJECT_NAME (new 21c)

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