SQL*Loader problem

[djb123]

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

[Raminder]

You might have to add a filler field.
RES_FILE FILLER CHAR

See the following links for more info on loading LOB data:

http://otn.oracle.com/docs/products/...ch03.htm#12968

http://otn.oracle.com/docs/products/.../ch04.htm#8383 (for examples)

[PSoni]

HI


it seems like error is due to u r using reserved 'DATA'
in ur fields

TRANS_ID,
DATA, (perhaps error is due to this on)
ATTEMPTS

change the name of field as DATA1 in table and in control file
try again.



P.Soni

[reydp]

PSoni is right, DATA is one of the SQL LOADER RESERVEd words.
You won't see this error if you're just using SQL/PLSQL.