Oracle | DBMS_SODA

Oracle DBMS_SODA_DML 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 Simple Oracle Document Access DML Support utilities.

AUTHID DEFINER

Dependencies

DBMS_JSON_LIB	DBMS_SODA_UTIL	JSON$COLLECTION_METADATA
DBMS_SODA_ADMIN

Documented No

First Available Not known

Security Model Owned by XDB with no privileges granted

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvtsodadml.plb

Subprograms

CLEAR_BIT	DO_LOCK
DO_DELETE	DO_READ_DESCRIPTOR
DO_DELETE_ALL	DO_UPDATE
DO_DELETE_COLLECTION_METADATA	DO_UPDATE_DESCRIPTOR
DO_DROP_DANGLING_COLLECTIONS	DO_UPDATE_MODE
DO_INSERT	SET_BIT

CLEAR_BIT

Undocumented dbms_soda_dml.clear_bit( owner IN VARCHAR2, table_name IN VARCHAR2);

exec xdb.dbms_soda_dml.clear_bit('C##UWCLASS', 'SERVERS');

           *

      PLS-00904: insufficient privilege to access object DBMS_SODA_DML

DO_DELETE

Undocumented dbms_soda_dml.do_delete( p_uri_name IN NVARCHAR2, p_owner IN VARCHAR2);

TBD

DO_DELETE_ALL

Undocumented dbms_soda_dml.do_delete_all(p_owner IN VARCHAR2);

exec xdb.dbms_soda_dml.do_delete_all('C##UWCLASS');

           *

      PLS-00904: insufficient privilege to access object DBMS_SODA_DML

DO_DELETE_COLLECTION_METADATA

Undocumented dbms_soda_dml.do_delete_collection_metadata(p_owner IN VARCHAR2);

exec xdb.dbms_soda_dml.do_delete_collection_metadata('C##UWCLASS');

           *

      PLS-00904: insufficient privilege to access object DBMS_SODA_DML

DO_DROP_DANGLING_COLLECTIONS

Undocumented dbms_soda_dml.do_drop_dangling_collections(p_owner IN VARCHAR2);

exec xdb.dbms_soda_dml.do_drop_dangling_collections('C##UWCLASS');

           *

      PLS-00904: insufficient privilege to access object DBMS_SODA_DML

DO_INSERT

Undocumented dbms_soda_dml.do_insert( p_uri_name IN NVARCHAR2, p_owner IN VARCHAR2, p_schema_name IN VARCHAR2, p_object_name IN VARCHAR2, p_object_type IN VARCHAR2, p_create_time IN TIMESTAMP, p_create_mode IN VARCHAR2, p_descriptor IN VARCHAR2);

TBD

DO_LOCK

Undocumented dbms_soda_dml.do_lock( p_uri_name IN NVARCHAR2, p_owner IN VARCHAR2, p_create_mode OUT VARCHAR2, p_timeout IN BINARY_INTEGER);

TBD

DO_READ_DESCRIPTOR

Undocumented dbms_soda_dml.do_read_descriptor( p_uri_name IN NVARCHAR2, p_owner IN VARCHAR2, p_descriptor OUT VARCHAR2, p_create_time OUT TIMESTAMP);

TBD

DO_UPDATE

Undocumented dbms_soda_dml.do_update( p_uri_name IN NVARCHAR2, p_owner IN VARCHAR2, p_schema_name IN VARCHAR2, p_object_name IN VARCHAR2, p_object_type IN VARCHAR2, p_create_time IN TIMESTAMP, p_create_mode IN VARCHAR2, p_descriptor IN VARCHAR2, p_row_count OUT NUMBER);

TBD

DO_UPDATE_DESCRIPTOR (new 23ai)

Undocumented dbms_soda_dml.do_update_descriptor( p_schema_name IN VARCHAR2, p_object_name IN VARCHAR2);

TBD

DO_UPDATE_MODE

Undocumented dbms_soda_dml.do_update_mode( p_uri_name IN NVARCHAR2, p_create_mode IN VARCHAR2, p_owner IN VARCHAR2);

TBD

SET_BIT

Undocumented dbms_soda_dml.set_bit( owner IN VARCHAR2, table_name IN VARCHAR2);

exec xdb.dbms_soda_dml.set_bit('C##UWCLASS', 'SERVERS');

           *

      PLS-00904: insufficient privilege to access object DBMS_SODA_DML