sqlldr issue with CLOBs

From: <mb71_at_my-deja.com>
Date: Tue, 19 Oct 1999 15:27:04 GMT
Message-ID: <7ui2jm$eq0$1@nnrp1.deja.com>

When I use the following control file to load CLOBs into the database:

LOAD DATA
INFILE *
INTO TABLE CONTENT
APPEND
FIELDS TERMINATED BY ','
( ID,

Name,
ext_fname FILLER CHAR(80),
DATA LOBFILE(ext_fname) TERMINIATED BY EOF) BEGINDATA
content_numbering.nextval,Test Name,990941450410.txt

I receive the following error, I have tried to follow the examples in the documentation but have had no success. I am using sqlldr80 on Win NT.

SQL*Loader: Release 8.0.5.0.0 - Production on Tue Oct 19 10:4:9 1999

SQL*Loader-350: Syntax error at line 8. Expecting "," or ")", found "FILLER".
ext_fname FILLER CHAR(80),

Thanks,
Mike

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 19 1999 - 10:27:04 CDT