SQLLDR80 LOBFILE ERROR

[pdwissink]

I received the following error when using sqlldr80 to load a lobfile

SQL*Loader-350: Syntax error at line 9.
Expecting "," or &quot", found "FILLER".
RES_FILE FILLER CHAR,

Here is my control file

OPTIONS (ROWS=20000,DIRECT=FALSE)
LOAD DATA
INFILE 'MFnotes.TXT'
badfile 'MFNOTES.BAD'
discardfile 'MFNOTES.DSC'
append into table motfuel.mfnotes
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(nebid CHAR,
RES_FILE FILLER CHAR,
NOTES LOBFILE(RES_FILE) RAW TERMINATED BY EOF
)

and here is my trial text file

000003204,R0003204.RTF

Any suggestions are appreciated

 

[MadMaxx]

Hi -
Looks to me like you're listing a column named
"RES_FILE FILLER" of type CHAR.

You can't have a column name with a space in it in Oracle.

Hope that helps,
-Maxx

 

[pdwissink]

Maxx,

I want to use RES_FILE as a filler. RES_FILE is not a column name of my file. I want
to place the file information referred to in RES_FILE and populate my CLOB column "NOTES".

Thanks.

Darrell

 

[pdwissink]

Found out the problem was I was using 8.0.5 of the sql loader. When I upgraded to 8.1.7 the problem went away.