Oracle DBMS_SODA_DOM
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 CURRENT_USER
Dependencies
DBMS_SODA_UTIL JSON_ELEMENT_T UTL_RAW
Documented No
exceptions
Error Code Reason
ORA-40441 JSON_SYNTAX_ERROR
ORA--40442 PROJ_SPEC_PATH_ERRORS
ORA-40457 PROJ_SPEC_ARRAY_ERRORS
ORA-40564 INVALID_SPEC
ORA-40628 PROJ_SPEC_JSON_INVALID
ORA-40629 PATCH_SPEC_JSON_INVALID
ORA-40667 PATCH_ROOT_REMOVAL_ERROR
First Available Not known
Security Model Owned by XDB with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmssodadom.sql
{ORACLE_HOME}/rdbms/admin/prvtsodadom.plb
Subprograms
 
JSON_MERGE_PATCH
Undocumented dbms_soda_dom.json_merge_patch(
jval       IN VARCHAR2,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN VARCHAR2;
TBD
 
JSON_MERGE_PATCH_B
Undocumented dbms_soda_dom.json_merge_patch_b(
jval       IN BLOB,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN BLOB;
TBD
 
JSON_MERGE_PATCH_C
Undocumented dbms_soda_dom.json_merge_patch_c(
jval IN CLOB,
jpatch IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN CLOB;
TBD
 
JSON_MERGE_PATCH_N
Undocumented dbms_soda_dom.json_merge_patch_n(
jval       IN NVARCHAR2,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN VARCHAR2;
TBD
 
JSON_MERGE_PATCH_NC
Undocumented dbms_soda_dom.json_merge_patch_nc(
jval       IN NCLOB,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN CLOB;
TBD
 
JSON_MERGE_PATCH_R
Undocumented dbms_soda_dom.json_merge_patch_r(
jval       IN RAW,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN RAW;
TBD
 
JSON_PATCH
Undocumented dbms_soda_dom.json_patch(
jval       IN VARCHAR2,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN VARCHAR2;
TBD
 
JSON_PATCH_B
Undocumented dbms_soda_dom.json_patch_b(
jval       IN BLOB,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN BLOB;
TBD
 
JSON_PATCH_C
Undocumented dbms_soda_dom.json_patch_c(
jval       IN CLOB,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN CLOB;
TBD
 
JSON_PATCH_N
Undocumented dbms_soda_dom.json_patch_n(
jval       IN NVARCHAR2,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN VARCHAR2;
TBD
 
JSON_PATCH_NC
Undocumented dbms_soda_dom.json_patch_nc(
jval       IN NCLOB,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN CLOB;
TBD
 
JSON_PATCH_R
Undocumented dbms_soda_dom.json_patch_r(
jval       IN RAW,
jpatch     IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN RAW;
TBD
 
JSON_SELECT
Undocumented dbms_soda_dom.json_select(
jval       IN VARCHAR2,
jselect    IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN VARCHAR2;
TBD
 
JSON_SELECT_B
Undocumented dbms_soda_dom.json_select_b(
jval       IN BLOB,
jselect    IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN BLOB;
TBD
 
JSON_SELECT_C
Undocumented dbms_soda_dom.json_select_c(
jval       IN CLOB,
jselect    IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN CLOB;
TBD
 
JSON_SELECT_N
Undocumented dbms_soda_dom.json_select_n(
jval       IN NVARCHAR2,
jselect    IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN VARCHAR2;
TBD
 
JSON_SELECT_NC
Undocumented dbms_soda_dom.json_select_nc(
jval       IN NCLOB,
jselect    IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN CLOB;
TBD
 
JSON_SELECT_R
Undocumented dbms_soda_dom.json_select_r(
jval       IN RAW,
jselect    IN VARCHAR2,
exceptions IN VARCHAR2 DEFAULT 'ALL')
RETURN RAW;
TBD
 
NUMBER_TO_HEX
Casts a number to hex dbms_soda_dom.number_to_hex(num IN NUMBER) RETURN VARCHAR2;
SELECT dbms_soda_dom.number_to_hex(42)
FROM dual;

DBMS_SODA_DOM.NUMBER_TO_HEX(42)
----------------------------------
00000000000000000000000000000002A
 
NUMBER_TO_STRING
Casts a number to a string dbms_soda_dom.number_to_string(num IN NUMBER) RETURN VARCHAR2;
SELECT dbms_soda_dom.number_to_string(42)
FROM dual;

DBMS_SODA_DOM.NUMBER_TO_STRING(42)
-----------------------------------
42
 
TIMESTAMP_TO_NUMBER
Undocumented dbms_soda_dom.timestamp_to_number(tstamp IN TIMESTAMP) RETURN NUMBER;
SELECT dbms_soda_dom.timestamp_to_number(SYSTIMESTAMP)
FROM dual;

DBMS_SODA_DOM.TIMESTAMP_TO_NUMBER(SYSTIMESTAMP)
-----------------------------------------------
                                     1.4226E+17
 
UUID_TO_HEX
Undocumented dbms_soda_dom.uuid_to_hex(uuid IN RAW) RETURN VARCHAR2;
DECLARE
 rawg raw(64);
 guid dbms_id;
 uuid dbms_id;
BEGIN
  SELECT sys_guid()
  INTO rawg
  FROM dual;

  dbms_output.put_line(rawg);
  dbms_output.put_line(dbms_soda_dom.uuid_to_hex(rawg));
END;
/
6410E7448B98435C922FA74E7BB8CAC5
6410E7448B98435C922FA74E7BB8CAC5

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
Database Security
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