Oracle Error SQL*Loader-00654: Variable length field exceeds maximum length.

Oracle Error Message

SQL*Loader-00654: Variable length field exceeds maximum length.

Reason for the Error

A variable length field (with a leading length subfield) exceeded its maximum allowable length. The maximum length is either the length specified in the SQL*Loader control file, or, the default if not specified (4kb).

Solution

Shorten the field and its length.