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

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