Oracle DBMS_SQLCONTROL_INTERNAL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx