How to fix the Oracle error SQL*Loader-00640: Variable length field was truncated.?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00640: Variable length field was truncated. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00640: Variable length field was truncated.

Reason for the Error SQL*Loader-00640: Variable length field was truncated.

The end of the logical record was encountered before the end of a variable length field. The length of each variable-length field is embedded in the field, so SQL*Loader knows that more data should have been present.

How to fix the Error SQL*Loader-00640: Variable length field was truncated. ?

You can fix this error in Oracle by following the below steps

Check the data for inadvertent truncation and verify the SQL*Loader control file specifications against the log file; the field may be starting in the wrong place.