sqlldr-Is there a limit on string length on varchar2 column being loaded?

[jt]

Hi, I am trying to load a text file (pipe delimited) into a table. There is one string that is supposed to get loaded to a varchar2(1500) column, but even the actual length of the string is definitely less than 500, the row gets rejected to bad file with error message

Record 1: Rejected - Error on table LOADITEMS, column MFG_LONG_PROD_DESCRIPT.
Field in data file exceeds maximum length

Do you know if there is a limit on the character length by sqlldr?

I am on Solaris 7 platform with oracle 8.1.6.

[sambavan]

Yes when you don't specify the text field size the loader would assume 255 characters. So in your ctl script, add char(your_varchar_size) and then loder would be happy to load this number of characters for you.

Good luck,
Sam

[jt]

Thanks alot! It worked!