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

The package appears to be protected with 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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx