Re: Unable to load a string of length 356 into VARCHAR2(2000) column

scjfan122yahoo.com wrote:

> Hi,
>
> I have been trying to load several text records into a table
> consisting a VARCHAR2(2000) column using SQL*Loader with delimiter.
> Most records with short text length have no problem being loaded into
> the table. However, for those with longer text lengths I keep getting
> the following error message in the log file:
>
> Record 1: Rejected - Error on table XXX, column YYY.
> Field in data file exceeds maximum length
>
> I counted the text length of one of the rejected record which had only
> 356 characters. I use "=" as the column delimiter. I do not
> understand why VARCHAR2(2000) can not hold 356 characters. Where did
> I miss?
>
> Thanks,
>
> Simon

It can. What I can't understand is why you would use a reserved character as a delimiter? Are tilde's and pipes broken on your keyboard?

But lets see ... no Oracle version and no control file so my suspicion as to what is wrong may be off-base.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)