Oracle DBMS_SODA_UTIL
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose This package is a PL/SQL package containing utilities supporting Simple Oracle Document Access (SODA).
AUTHID DEFINER
Data Types TYPE intntab IS TABLE OF PLS_INTEGER;

TYPE vctab IS TABLE OF VARCHAR2(32767) INDEX BY BINARY_INTEGER;
Dependencies
DBA_SEQUENCES DBMS_SODA_ADMIN JSON_OBJECT_T
DBA_TABLES DBMS_SODA_DML NLS_DATABASE_PARAMETERS
DBA_TAB_COLS DBMS_SODA_DOM P:ITBLM
DBA_VIEWS DBMS_SYS_ERROR V$DATABASE
DBMS_SODA JSON_ELEMENT_T V$PARAMETER
Documented No
First Available 19c
Security Model Owned by SYS with EXECUTE granted to XDB

The package is access protected by the following ACCESSIBLE BY clause:

ACCESSIBLE BY (
  PACKAGE xdb.dbms_soda_admin,
  PACKAGE xdb.dbms_soda_dom,
  PACKAGE xdb.bsms_soda_dml,
  PACKAGE sys.dbms_soda)
Source {ORACLE_HOME}/rdbms/admin/dbmssodautil.sql
{ORACLE_HOME}/rdbms/admin/prvtsodautil.plb
Subprograms
CHECKANDGETCOMPAT GETCHARSET GETSERVICENAME
CHECKAUTOINDEXLENGTH GETCOLUMNLENGTH ISOLDDRIVERANDJSONCOLL
CHECKCOLUMNS GETCOMPATANDFLAG LIST_USAGE_STATISTICS
CHECKCOMPAT GETLONGSTRINGENABLED MAPPEDCONTENTCOLUMN
CHECKSEQUENCEEXISTS GETNLSCHARSET PARSEBOOLEANFLAG
CHECKTABLEEXISTS GETSCHEMACONSTRAINT RAISE_SYSTEM_ERROR
CHECKVIEWEXISTS GETSCN  
 
CHECKANDGETCOMPAT
Undocumented dbms_soda_util.checkAndGetCompat RETURN NUMBER;
SELECT dbms_soda_util.checkAndGetCompat;
*
PRA-06553: PLS-904: insufficient privilege to access object DBMS_SODA_UTIL
 
CHECKAUTOINDEXLENGTH (new 23ai)
Undocumented dbms_soda_util.checkAutoIndexLength RETURN BOOLEAN;
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
 
GETCOLUMNLENGTH (new 23ai)
Undocumented

The source code shows p_objname defined as VARCHAR rather than as VARCHAR2		 dbms_soda_util.getColumnLength(
p_schema  IN  VARCHAR2,
p_objname IN  VARCHAR,
p_colname IN  VARCHAR2,
p_length  OUT NUMBER);
Protected by an ACCESSIBLE BY clause
 
GETCOMPATANDFLAG (new 23ai)
Undocumented dbms_soda_util.getCompatAndFlag(
p_soda_flags OUT VARCHAR2,
p_compatible OUT NUMBER);
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
 
GETSCHEMACONSTRAINT (new 23ai)
Undocumented dbms_soda_util.getschemaconstraint(
p_descriptor      IN  VARCHAR2,
p_table_name      OUT VARCHAR2,
p_schema_name     OUT VARCHAR2,
p_constraint_name OUT VARCHAR2);
TBD
 
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
 
ISOLDDRIVERANDJSONCOLL (new 23ai)
Undocumented dbms_soda_util.isOldDriveAndJSONColl(
p_23c_driver IN BOOLEAN,
p_descriptor IN VARCHAR2);
RETURN BOOLEAN;
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
 
MAPPEDCONTENTCOLUMN (new 23ai)
Undocumented dbms_soda_util.mappedContentColumn(
p_table_name IN VARCHAR2,
p_schema     IN VARCHAR2)
RETURN VARCHAR2;
Protected by an ACCESSIBLE BY clause
 
PARSEBOOLEANFLAG (new 23ai)
Undocumented dbms_soda_util.parseBooleanFlag(
p_soda_flags IN VARCHAR2,
p_flag_name  IN VARCHAR2)
RETURN BOOLEAN;
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 26ai

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