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

Direct access to some objects in this package is prevented by means of an Accessible By clause.
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 (new 21c)
Undocumented dbms_soda_util.getServiceName RETURN VARCHAR2;
Protected by an ACCESSIBLE BY clause
 
LIST_USAGE_STATISTICS (new 21c)
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 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx