Oracle | DBMS_SODA_UTIL

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	CHECKVIEWEXISTS	GETSCN
CHECKCOLUMNS	GETCHARSET	GETSERVICENAME
CHECKCOMPAT	GETLONGSTRINGENABLED	LIST_USAGE_STATISTICS
CHECKSEQUENCEEXISTS	GETNLSCHARSET	RAISE_SYSTEM_ERROR
CHECKTABLEEXISTS

CHECKANDGETCOMPAT

Undocumented dbms_soda_util.checkAndGetCompat RETURN NUMBER;

Protected by an ACCESSIBLE BY clause

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

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

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

Undocumented dbms_soda_util.getNLSCharset(p_cs OUT VARCHAR2);

Protected by an ACCESSIBLE BY clause

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_ADMIN

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