Oracle | DBMS_JSON

Oracle DBMS_JSON_SCHEMA 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 JSON Schema Validation utilities

AUTHID CURRENT_USER

Dependencies

ALL_JSON_DUALITY_VIEWS	DBMS_ASSERT
ALL_JSON_DUALITY_VIEW_LINKS	INT$DBA_JSON_DUALITY_VIEWS
ALL_JSON_DUALITY_VIEW_TABS	INT$DBA_JSON_DUALITY_VIEW_LINKS
ALL_JSON_DUALITY_VIEW_TAB_COLS	INT$DBA_JSON_DUALITY_VIEW_TABS
DBA_JSON_DUALITY_VIEWS	INT$DBA_JSON_DUALITY_VIEW_TAB_COLS
DBA_JSON_DUALITY_VIEW_LINKS	USER_JSON_DUALITY_VIEWS
DBA_JSON_DUALITY_VIEW_TABS	USER_JSON_DUALITY_VIEW_LINKS
DBA_JSON_DUALITY_VIEW_TAB_COLS	USER_JSON_DUALITY_VIEW_TABS
DBMSJSONSV_LIB	USER_JSON_DUALITY_VIEW_TAB_COLS

Documented No

First Available 23ai

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsjsonsv.sql
{ORACLE_HOME}/rdbms/admin/prvtjsonsv.plb

Subprograms

DESCRIBE	IS_VALID	RESULT_INVALID
FORMAT_JSON	RAISE_ERROR	RESULT_VALID
FORMAT_OSON	RAISE_NONE	VALIDATE_REPORT
IS_SCHEMA_VALID

DESCRIBE (new 23ai)

Undocumented dbms_json_schema.describe( object_name IN VARCHAR2, owner_name IN VARCHAR2 DEFAULT NULL, column_name IN VARCHAR2 DEFAULT NULL) RETURN JSON;

TBD

FORMAT_JSON (new 23ai)

Undocumented dbms_json_schema.format_json RETURN PLS_INTEGER PARALLEL_ENABLE;

TBD

FORMAT_OSON (new 23ai)

Undocumented dbms_json_schema.format_oson RETURN PLS_INTEGER PARALLEL_ENABLE;

TBD

IS_SCHEMA_VALID (new 23ai)

Schema validation/ingestion interfaces

Overload 1 dbms_json_schema.is_schema_valid(json_data IN VARCHAR2) RETURN PLS_INTEGER;

TBD

Overload 2 dbms_json_schema.is_schema_valid(json_data IN JSON) RETURN PLS_INTEGER;

TBD

IS_VALID (new 23ai)

Undocumented

Overload 1 dbms_json_schema.is_valid( json_data IN VARCHAR2, json_schema IN VARCHAR2, raise_err IN PLS_INTEGER DEFAULT dbms_json_schema.raise_none) RETURN PLS_INTEGER;

TBD

Overload 2 dbms_json_schema.is_valid( json_data IN BLOB, json_schema IN BLOB, raise_err IN PLS_INTEGER DEFAULT dbms_json_schema.raise_none, format IN PLS_INTEGER DEFAULT dbms_json_schema.formagt_json) RETURN PLS_INTEGER;

TBD

Overload 3 dbms_json_schema.is_valid( json_data IN BFILE, json_schema IN BFILE, raise_err IN PLS_INTEGER DEFAULT dbms_json_schema.raise_none, format IN PLS_INTEGER DEFAULT dbms_json_schema.formagt_json) RETURN PLS_INTEGER;

TBD

Overload 4 dbms_json_schema.is_valid( json_data IN CLOB, json_schema IN CLOB, raise_err IN PLS_INTEGER DEFAULT dbms_json_schema.raise_none) RETURN PLS_INTEGER;

TBD

Overload 5 dbms_json_schema.is_valid( json_data IN JSON, json_schema IN JSON, raise_err IN PLS_INTEGER DEFAULT dbms_json_schema.raise_none) RETURN PLS_INTEGER;

TBD

Overload 6 dbms_json_schema.is_valid( json_data IN JSON, json_schema IN JSON, result OUT BOOLEAN, errors OUT JSON);

TBD

RAISE_ERROR (new 23ai)

Error action dbms_json_schema.raise_error RETURN PLS_INTEGER PARALLEL_ENABLE;

TBD

RAISE_NONE (new 23ai)

Error action dbms_json_schema.raise_none RETURN PLS_INTEGER PARALLEL_ENABLE;

TBD

RESULT_INVALID (new 23ai)

Schema validation dbms_json_schema.result_invalid RETURN PLS_INTEGER PARALLEL_ENABLE;

TBD

RESULT_VALID (new 23ai)

Schema validation dbms_json_schema.result_valid RETURN PLS_INTEGER PARALLEL_ENABLE;

TBD

VALIDATE_REPORT (new 23ai)

Undocumented

Overload 1 dbms_json_schema.validate_report( json_data IN VARCHAR2, json_schema IN VARCHAR2) RETURN JSON;

TBD

Overload 2 dbms_json_schema.validate_report( json_data IN JSON, json_schema IN JSON) RETURN JSON;

TBD