Oracle | DBMS_JSON

Oracle DBMS_JSON_SCHEMA Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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 23.1

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 23c)

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

TBD

FORMAT_JSON (new 23c)

Undocumented dbms_json_schema.format_json RETURN PLS_INTEGER PARALLEL_ENABLE; PRAGMA SUPPLEMENTAL_LOG_DATA(FORMAT_JSON, READ_ONLY);

TBD

FORMAT_OSON (new 23c)

Undocumented dbms_json_schema.format_oson RETURN PLS_INTEGER PARALLEL_ENABLE; PRAGMA SUPPLEMENTAL_LOG_DATA(FORMAT_OSON, READ_ONLY);

TBD

IS_SCHEMA_VALID (new 23c)

Schema validation/ingestion interfaces

Overload 1 dbms_json_schema.is_schema_valid(json_data IN VARCHAR2) RETURN PLS_INTEGER; PRAGMA SUPPLEMENTAL_LOG_DATA(is_schema_valid, READ_ONLY);

TBD

Overload 2 dbms_json_schema.is_schema_valid(json_data IN JSON) RETURN PLS_INTEGER; PRAGMA SUPPLEMENTAL_LOG_DATA(is_schema_valid, READ_ONLY);

TBD

IS_VALID (new 23c)

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; PRAGMA SUPPLEMENTAL_LOG_DATA(is_valid, READ_ONLY);

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; PRAGMA SUPPLEMENTAL_LOG_DATA(is_valid, READ_ONLY);

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; PRAGMA SUPPLEMENTAL_LOG_DATA(is_valid, READ_ONLY);

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; PRAGMA SUPPLEMENTAL_LOG_DATA(is_valid, READ_ONLY);

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; PRAGMA SUPPLEMENTAL_LOG_DATA(is_valid, READ_ONLY);

TBD

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

TBD

RAISE_ERROR (new 23c)

Error action dbms_json_schema.raise_error RETURN PLS_INTEGER PARALLEL_ENABLE; PRAGMA SUPPLEMENTAL_LOG_DATA(RAISE_ERROR, READ_ONLY);

TBD

RAISE_NONE (new 23c)

Error action dbms_json_schema.raise_none RETURN PLS_INTEGER PARALLEL_ENABLE; PRAGMA SUPPLEMENTAL_LOG_DATA(RAISE_NONE, READ_ONLY);

TBD

RESULT_INVALID (new 23c)

Schema validation dbms_json_schema.result_invalid RETURN PLS_INTEGER PARALLEL_ENABLE; PRAGMA SUPPLEMENTAL_LOG_DATA(RESULT_INVALID, READ_ONLY);

TBD

RESULT_VALID (new 23c)

Schema validation dbms_json_schema.result_valid RETURN PLS_INTEGER PARALLEL_ENABLE; PRAGMA SUPPLEMENTAL_LOG_DATA(RESULT_VALID, READ_ONLY);

TBD

VALIDATE_REPORT (new 23c)

Undocumented

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

TBD

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

TBD