ORA-40092
DEFAULT ON ERROR or DEFAULT ON EMPTY is not supported by JSON_VALUE returning VECTOR type
Cause
DEFAULT ON ERROR or DEFAULT ON EMPTY is specified for a JSON_VALUE operation that returns a VECTOR type, which is not supported.
Action
Specify a different option for the ON ERROR or ON EMPTY clause, or omit the clause to use the default ON ERROR or ON EMPTY option.