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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.