Correct settings in SQL*Loader control file

I'm having problems with SQL*Loader.

This is the top of my control file.

LOAD DATA
INFILE mydata.dat "str X'7C7C'"
INTO TABLE evals_tmp
APPEND
FIELDS TERMINATED BY X'0A'
TRAILING NULLCOLS One of the fields corresponds to a VARCHAR2(1000) in the eval_tmp table. I was getting errors about the data being too long, if the column had more than 255 characters, until I changed the line in the control file to:

DELIVERYCOMMENTS char(1000) "SUBSTR(:deliverycomments,1,1000)", NRESP1,
NRESP2, That stopped that particular error. Now, however, if the field data in the data file is actually longer than 1000 characters, it gets an error on the next field (NRESP1), saying that the data is too long. What should I put in the control file so that it will still import the record and simply discard any data beyond the 1000 characters for this field? Received on Sun May 15 2005 - 22:52:46 CDT