Oracle | DBMS_SODA

Oracle DBMS_SODA_DML 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

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 means of an Accessible By clause.

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

Subprograms

CLEAR_BIT	DO_DROP_DANGLING_COLLECTIONS	DO_UPDATE
DO_DELETE	DO_INSERT	DO_UPDATE_MODE
DO_DELETE_ALL	DO_LOCK	SET_BIT
DO_DELETE_COLLECTION_METADATA	DO_READ_DESCRIPTOR

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');

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

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_SODA_DML

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

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');

      BEGIN xdb.dbms_soda_dml.do_delete_all('C##UWCLASS'); END;

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_SODA_DML

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

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');

      BEGIN xdb.dbms_soda_dml.do_delete_collection_metadata('C##UWCLASS'); END;

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_SODA_DML

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

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');

      BEGIN xdb.dbms_soda_dml.do_drop_dangling_collections('C##UWCLASS'); END;

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_SODA_DML

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

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_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');

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

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_SODA_DML

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored