sql loader maximum lenght exceeded error

From: <kevinator_ca_at_yahoo.com>
Date: Wed, 23 Feb 2000 21:32:36 GMT
Message-ID: <891jlk$f6v$1@nnrp1.deja.com>

hello,

I'm wondering if everyone has ever had this problem before. I'm user SQL*Loader 8.1.5 for Oracle 8i. I keep getting an error on a field in a file that I'm loader. The error says the field exceeds the maximum length. the field is only one character long. When I look at the rejected records, the field in the file is only one character long but it's a black, whitespace, ascii(32). At first the data type was VARCHAR2 (1) then I changed it to CHAR(1) to amuse myself. Is this a common error because it only occurs when there are blanks in the data. One of my co-workers said this happened to him last week but I didn't believe him, now I do.
Thanks in advance for your help.

kevin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 23 2000 - 15:32:36 CST