OCI-63878
BY NAME or POSITION are semantic modifiers of the subquery only and are not compatible with the VALUES clause.
Cause
BY NAME or POSITION are not compatible with the VALUES clause.
Action
Remove either BY NAME or POSITION clause, or the VALUES clause.