Re: sqlldr and large text files

Try putting in your control file the max char value of the feild like this:
LOAD DATA
INFILE 'off.txt'
INTO TABLE offering
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '~' (region_id, district_id, comp_id, category, offering, description

**************CHAR(1000)****************, contact, percent_accepted,

oh and don't add the **, I could not get a 1000 character description to load until I did this then everything went in fine just make sure that the feild you are using in the table can handle the char size.

On Wed, 09 Jul 1997 13:49:49 -0700, John Caputo <caputo1_at_llnl.gov> wrote:

>Lisa M. Lewis wrote:
>>
>> I am trying to load a larger ( > 256 and < 500 ) character string with
>> sqlldr. I am using d:\orant\bin\sqlldr73.exe ( 3/8/97). It is not
>> working and I'm not sure why. I have read the previous posts on this
>> topic and feel that I have complied. Can anyone help?
>>
>> The error I get is as follows in the log file:
>>
>> Record 15384: Rejected - Error on table LOCATIONS, column LOCATION
>> ORA-02359: Field in data file exceeded maximum specified length
>>
>> The following entry ends up in the bad file:
>>
>> "/regional/countries/canada/provinces_and_territories/ontario/counties_and_regions/greater_toronto_area__gta_/metropolitan_toronto/north_york/education/colleges_and_universities/york_university/departments_and_programs/writers_in_electronic_residence__wier__program/"
>> 35702
>>
Received on Fri Jul 11 1997 - 00:00:00 CEST