1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. JSON_EXPRESSION_CHECK

2.185 JSON_EXPRESSION_CHECK

Use JSON_EXPRESSION_CHECK to enable or disable JSON query statement checking.

Property Description

Parameter type

String

Syntax

JSON_EXPRESSION_CHECK = { ON | OFF }

Default value

OFF

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

Different instances can use different values.

Set this parameter to ON to enable JSON query statement checking; set it to OFF to disable JSON query statement checking.

Note:

This parameter is available starting with Oracle Database 23ai.

See Also:

JSON-Relational Duality Developer's Guide for more information about JSON_EXPRESSION_CHECK