How to fix the Oracle error SQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table string?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table string

Reason for the Error SQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table string

The SQL*Loader control file specifies two different lengths for the named column. There are three ways to specify the length of a field: –with the POSITION keyword: POSITION(1:3) — with the length specifier: CHAR(6) — with the implied length of a datatype; for example, INTEGER — A conflict could occur between any two of these specifications (or among all three, but only two are shown). A common cause of this error is the specification of some numeric datatype, such as INTEGER, when the numeric external form is intended (INTEGER EXTERNAL). The external form consists of character data, so it is considerably longer than the numeric form, which consists of binary data.

How to fix the Error SQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table string ?

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

No action is necessarily required, because SQL*Loader uses only one of the lengths. Check the log file under the heading “Len” in the table-description section to see which length was used. Adjusting the SQL*Loader control file to produce uniform length specifications will remove the warning.