Oracle Error SQL*Loader-00427: a field condition references a non-scalar field or a LOB field string

Oracle Error Message

SQL*Loader-00427: a field condition references a non-scalar field or a LOB field string

Reason for the Error

The field condition is referencing a field which is either a nested table, varray, column object, LOB or BILE field. These fields with these typescannot be references by other field.

Solution

Correct the NULLIF, DEFAULTIF, or WHEN clauses to reference only non-LOB scalar data fields.