Loading in-line data in a CLOB

From: Andy Kent <andykent.bristol1095_at_virgin.net>
Date: 14 Oct 2005 03:41:20 -0700
Message-ID: <1129286480.076007.126480@g47g2000cwa.googlegroups.com>

I am trying to load data into a table containing a CLOB. All the data is held in the one input file, rather than the CLOB data being held in separate files. Using the control file below (the CLOB column is "description") it works for rows where the input text is less than
(very) roughly 80-100 bytes but gets "Field in data file exceeds
maximum length" if the text is longer than this.

Can this be done in SQL*Loader or do I need to use one of the DBMS packages?

Thanks,
Andy

It's 9.2 on Windows 2000.

Control file:

LOAD DATA
INFILE 'action.txt'
BADFILE 'action.bad'
DISCARDFILE 'action.dsc'
TRUNCATE
INTO TABLE action FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(id,description,date_ DATE(20) "DD/MM/YYYY
HH:MI:SS",cleared,actionee,callreportno,client,opportunity,datedue,prospectno) Received on Fri Oct 14 2005 - 05:41:20 CDT