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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SQLQ
DBMS_SQLQ_INTERNAL
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2022 Daniel A. Morgan All Rights Reserved
  DBSecWorx