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 is now availble. If you haven't you downloaded already: Why?

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