Re: Sqlload Varchars?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 29 May 1999 01:10:03 GMT
Message-ID: <374f3e5b.1240894@newshost.us.oracle.com>

A copy of this was sent to Ron Cline <ronjc_at_mindspring.com> (if that email address didn't require changing) On Fri, 28 May 1999 15:34:08 -0400, you wrote:

>I'm setting up a control file to load records. One of the fields is a
>VARCHAR(1400) and has been giving me problems:
>
>LOAD
>INSERT
>INTO TABLE X
>APPEND
>FIELDS
>(FieldA TERMINATED BY '|',
> FieldB TERMINATED BY '|',
> Problem TERMINATED BY '|'
>)
>
>I'm taking the default for field "problem" here so it is CHAR.
>However, I get the error that column is too large, so I'm guessing the
>CHAR
>here only allows around 255 chars. My data is around 500 chars long.
>
>I haven't had any luck declaring something like
>Problem VARCHAR (1400) TERMINATED BY '|' or
>Problem VARCHAR TERMINATED BY '|'
>
>How can I declare a Varchar? What syntax would work?

char(1400) would work. use char in sqlldr.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri May 28 1999 - 20:10:03 CDT