ORA-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.