Oracle DBMS_SODA_UTIL
Version 26ai

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

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
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