Re: sqlloader problem

"Dorothea Kuehn" <dekay_at_zedat.fu-berlin.de> wrote in message news:8gmb6b$1jr41$1_at_fu-berlin.de...
> I'm having trouble loading some lengthy textcolumns with sqlldr. The .ctl
> file looks like this:
>
> load data
> infile 'desc.dat'
> into table foo.descriptions
> fields terminated by X'07' trailing nullcols
> (
> rid,
> description)
>
> The input data file is correctly delimited (linefeeds as record
> delimiters, the linefeeds in the description texts are replaced).
> 'rid' is some number, 'description' is of type 'LONG' in Oracle.
>
> If the description text is longer than about 3 lines (255 chars??),
> the loader rejects the record with:
>
> Field in data file exceeds maximum length.
>
> Why? What can I do to load these data?
>
> (Oracle/SQL*Loader is 8.1.6 for Solaris)
>
> thanks for help,
> dekay

[Quoted] Just guessing but the default datatype for SQL*Loader is CHAR. Try defining your description column as a LONG...?

-Matt Received on Tue May 30 2000 - 00:00:00 CEST