Question: using SQLLoader to load a VARCHAR(2000) field

From: QIANG01 <qiang01_at_aol.com>
Date: 1998/02/17
Message-ID: <19980217161601.LAA11456@ladder03.news.aol.com>#1/1

Dear Oracle experts,

I have a question on SQLLoader (Release 7.3.2.2.0).

I want to load a data file into a table, which is defined as:

temp_table
(
long_string VARCHAR2(2000)
)

As long as the field in the file is longer than 258 characters, I got a "Field in data file exceeded maximum specified length".

Oracle defines VARCHAR2's maximum length as 2000, so I don't understand how this could happen. I tried to use 'PIECED' option as well as setting BINDSIZE to a big number using Direct Load, but it just doesn't work. Does this have anything to do with CHAR's maximum length is 255?

Your help is greatly appreciated!!!

Please email chan9055_at_cs.nyu.edu. Thanks. Song Chang
auto parts Received on Tue Feb 17 1998 - 00:00:00 CST