sqlldr problem

From: <akvalang_at_my-deja.com>
Date: 2000/05/06
Message-ID: <8f1pft$872$1@nnrp1.deja.com>#1/1

Hello.

I am using Oracle 8.1.6 on Solaris 7. I am trying to load a commadelimited text file that has about 800 columns into one table using sql loader. And I get the following error 50 times for each record (I have a couple of hundred records total in the file), and none of the records get loaded.

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

COLUMN_NAME has 3240 characters in each of the fields in the inputfile, and it is defined as VARCHAR2(4000) in the destination table and as CHAR in the sql loader control file. So it "should" have enough space for the whole record.

Do you have any ideas on what the problem here might be. I would appreciate any help.

Thanks in advance.
Alex.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat May 06 2000 - 00:00:00 CDT