Oracle DBMS_SODA_DML
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SODA
DBMS_SODA_ADMIN
DBMS_SODA_DOM
DBMS_SODA_USER_ADMIN
DBMS_SODA_USER_DML
DBMS_SODA_UTIL
SODA for PL/SQL
What's New In 19c
What's New In 20c-21c

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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx