SQL*Loader-404: Column CHAR present more than once

Problem:

When loading data via SQL*Loader into a table on an 11g database, the following message appears:

SQL*Loader-404: Column CHAR present more than once in APPS.TMP_HRDPV_CREATE_IN_CWK's 
INTO TABLE block.

Solution:

In the SQL*Loader control file, the column names had comma after them. There should be whitespace, and then CHAR followed by comma.

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.