Hi again,

I'm trying to load a comma delimited flatfile into a database, which contains a CLOB column and am getting an error. Please help if you can! Here's what my control file looks like:

LOAD DATA
INFILE 'E:\HUB_STORE.txt'
BADFILE 'E:\HUB_STORE.bad'
DISCARDFILE 'E:\HUB_STORE.dsc'

INTO TABLE "HUB_STORE"
REENABLE DISABLED_CONSTRAINTS

FIELDS TERMINATED BY ','
TRAILING NULLCOLS

(MSG_ID,
SENDER_ID,
RECEIVER_ID,
MSG_TYPE_ID,
MSG_STATUS_ID,
TRANS_ID,
DATA,
ATTEMPTS,
TIME_CREATED,
TIME_OF_LAST_ATTEMPT,
TIME_COMPLETED,
NOTIF_CREATED)


I get the error message:

SQL*Loader-350: Syntax error at line 18.
Expecting field-name, found keyword data.
DATA,
^

As this is my first time loading data into a database using SQL*Loader, I'm at a loss. The CLOB column can be very large in some cases as it's basically an XML document within that column. Can anyone enlighten me as to what exactly the problem and possible solution are?

Many thanks,
David