Oracle | DBMS_SODA

Oracle DBMS_SODA_DOM 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 DOM utilities

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	JSON_PATCH_C	JSON_SELECT_N
JSON_MERGE_PATCH_B	JSON_PATCH_N	JSON_SELECT_NC
JSON_MERGE_PATCH_C	JSON_PATCH_NC	JSON_SELECT_R
JSON_MERGE_PATCH_N	JSON_PATCH_R	NUMBER_TO_HEX
JSON_MERGE_PATCH_NC	JSON_SELECT	NUMBER_TO_STRING
JSON_MERGE_PATCH_R	JSON_SELECT_B	TIMESTAMP_TO_NUMBER
JSON_PATCH	JSON_SELECT_C	UUID_TO_HEX
JSON_PATCH_B

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

      

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

      

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

      

      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.