Oracle Error SQL*Loader-00289: SQL string for column string occludes SQL string for column string.

Oracle Error Message

SQL*Loader-00289: SQL string for column string occludes SQL string for column string.

Reason for the Error

A SQL string has been associated with both a column object and one of its attributes in the control file. Because the SQL string of the column object will replace the entire column object in the VALUE clause of the INSERT statement, the SQL string of the attribute is ignored. This could cause unexpected or incorrect values to be loaded.

Solution

Correct the control file so that only the column object or its attribute has a SQL string, but not both.