Oracle DBMS_SODA_UTIL
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 Undocumented
AUTHID DEFINER
Data Types TYPE vctab IS TABLE OF VARCHAR2(32767) INDEX BY BINARY_INTEGER;
Dependencies
DBA_SEQUENCES DBMS_SODA_ADMIN NLS_DATABASE_PARAMETERS
DBA_TABLES DBMS_SODA_DML V$DATABASE
DBA_TAB_COLS DBMS_SODA_DOM V$PARAMETER
DBA_VIEWS DBMS_SYS_ERROR  
Documented No
First Available 19c
Security Model Owned by SYS with no privileges granted

accessible by
(package xdb.dbms_soda_admin, package xdb.dbms_soda_dom,
package xdb.dbms_soda_dml, package sys.dbms_soda)
Source {ORACLE_HOME}/rdbms/admin/dbmssodautil.sql
{ORACLE_HOME}/rdbms/admin/prvtsodautil.plb
Subprograms
 
CHECKANDGETCOMPAT
Undocumented dbms_soda_util.checkAndGetCompat RETURN NUMBER;
Protected by an ACCESSIBLE BY clause
 
CHECKCOLUMNS
Undocumented dbms_soda_util.checkColumns(
p_schema   IN  VARCHAR2,
p_objname  IN  VARCHAR2,
p_ncols    IN  BINARY_INTEGER,
p_colnames IN  sys.dbms_soda_util.vctab,
p_coltypes IN  sys.dbms_soda_util.vctab,
p_found    OUT BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
CHECKCOMPAT
Undocumented dbms_soda_util.checkCompat;
Protected by an ACCESSIBLE BY clause
 
CHECKSEQUENCEEXISTS
Undocumented dbms_soda_util.checkSequenceExists(
p_schema  IN  VARCHAR2,
p_seqname IN  VARCHAR2,
p_found   OUT BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
CHECKTABLEEXISTS
Undocumented dbms_soda_util.checkTableExists(
p_schema  IN  VARCHAR2,
p_tabname IN  VARCHAR2,
p_found   OUT BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
CHECKVIEWEXISTS
Undocumented dbms_soda_util.checkViewExists(
p_schema   IN  VARCHAR2,
p_viewname IN  VARCHAR2,
p_found    OUT BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
GETCHARSET
Undocumented dbms_soda_util.getCharset(p_cs OUT VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
GETLONGSTRINGENABLED
Undocumented dbms_soda_util.getLongStringEnabled(p_long_strings OUT VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
GETNLSCHARSET
Undocumented dbms_soda_util.getNLSCharset(p_cs OUT VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
GETSCN
Undocumented dbms_soda_util.getSCN(p_scn OUT NUMBER);
Protected by an ACCESSIBLE BY clause
 
GETSERVICENAME
Undocumented dbms_soda_util.getServiceName RETURN VARCHAR2;
Protected by an ACCESSIBLE BY clause
 
LIST_USAGE_STATISTICS
Undocumented dbms_soda_util.list_usage_statistics(
p_owner       IN  VARCHAR2,
p_statistics  OUT VARCHAR2,
p_access_type IN  VARCHAR2 DEFAULT 'READ',
p_sort        IN  NUMBER   DEFAULT 1,
p_limit       IN  NUMBER   DEFAULT 100);
Protected by an ACCESSIBLE BY clause
 
RAISE_SYSTEM_ERROR
Undocumented

Overload 1
dbms_soda_util.raise_system_error(
error_number IN NUMBER,
arg1         IN VARCHAR2,
arg2         IN VARCHAR2,
arg3         IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
Undocumented

Overload 2
dbms_soda_util.raise_system_error(
error_number IN NUMBER,
arg1         IN VARCHAR2,
arg2         IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
Undocumented

Overload 3
dbms_soda_util.raise_system_error(
error_number IN NUMBER,
arg1         IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
Undocumented

Overload 4
dbms_soda_util.raise_system_error(error_number IN NUMBER);
Protected by an ACCESSIBLE BY clause

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SODA
DBMS_SODA_ADMIN
DBMS_SODA_DML
DBMS_SODA_DOM
DBMS_SODA_USER_ADMIN
DBMS_SODA_USER_DML
SODA for PL/SQL
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