Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

OCI-40098

invalid option for ON EMPTY clause in JSON_TRANSFORM for path string

Cause

An invalid option for the ON EMPTY clause is provided for the JSON_TRANSFORM operation.


Action

Specify a different option for ON EMPTY, or omit the ON EMPTY clause and accept the default ON EMPTY option for this operator. Common ON MISMATCH options are ERROR ON EMPTY, IGNORE ON MISMATCH, or NULL ON EMPTY.