Oracle DBMS_SQLCONTROL_INTERNAL
Version 19.3

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
 
I_ALTER_OBJECT (new 19c)
Undocumented

Overload 1
dbms_sqlcontrol_internal.i_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.i_alter_object(
signature       IN NUMBER,
type            IN NUMBER,
attribute_name  IN VARCHAR2,
attribute_value IN VARCHAR2)
RETURN BINARY_INTEGER;
TBD
 
I_CREATE_OBJECT (new 19c)
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
 
I_DROP_OBJECT (new 19c)
Undocumented

Overload 1
dbms_sqlcontrol_internal.i_drop_object(
name IN VARCHAR2,
type IN NUMBER)
RETURN BINARY_INTEGER;
TBD
Overload 2 dbms_sqlcontrol_internal.i_drop_object(
signature IN NUMBER,
type      IN NUMBER)
RETURN BINARY_INTEGER;
TBD
 
I_EXISTS_OBJECT (new 19c)
Undocumented

Overload 1
dbms_sqlcontrol_internal.i_exists_object(
SQL_TEXT IN CLOB,
type     IN NUMBER,
plan_id  IN NUMBER,
category IN VARCHAR2)
RETURN BOOLEAN;
TBD
Overload 2 dbms_sqlcontrol_internal.i_exists_object(
name IN VARCHAR2,
type IN NUMBER)
RETURN BOOLEAN;
TBD

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

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