ORA-44977
invalid ON MISSING, ON EXISTING, ON MISMATCH, ON EMPTY, ON ERROR or ON NULL clause in JSON_TRANSFORM
Cause
The provided ON MISSING, ON EXISTING, ON MISMATCH, ON EMPTY, ON ERROR or ON NULL clause was invalid or not allowed for the seleced JSON_TRANSFORM operation.
Action
Provide a valid ON MISSING, ON EXISTING, ON MISMATCH, ON EMPTY, ON ERROR or ON NULL clause.