ORA-40100
invalid option for ON MISMATCH clause in JSON_TRANSFORM for path string
Cause
An invalid option for the ON MISMATCH clause is provided for the JSON_TRANSFORM operation.
Action
Specify a different option for ON MISMATCH, or omit the ON MISMATCH clause and accept the default ON MISMATCH option for this operator. Common ON MISMATCH options are ERROR ON MISMATCH, IGNORE ON MISMATCH, or NULL ON MISMATCH.