Web Development

Ask something
Discussion Locked

SQL*Loader Error Message

0 helpful
3 replies

by timothy.nelson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to load data from a flat file into an Oracle table and getting an error message of Field in data file exceeds maximum length for values in a column that exceed 256 characters. The field size on my source database, which I am creating theflat file from, is a VARCHAR2(500) and in my temp table, which I am trying to load the data into when I'm getting this error message, has a VARCHAR2(1000) field size. I'm not understanding why this is happening. Can anybody help me?

3 replies

by john_wills

Take a look at the flat file: it may turn out that the download from the source database is not working right.

by timothy.nelson

I just received an answer to this question from another source. What happened was that in SQL*Loader it has a max length of 256 for loading varchar2 columns, so we had to trick the system by putting in the control file for this field char(1000) to get it to load.

This discussion is closed to new replies.