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 (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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_JSON
DBMS_JSON0
DBMS_JSON_DUALITY
DBMS_JSON_INT
JSON Functionality
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx