Re: SQL*Loader and BLOBs

Well, I eventually figured this one out myself

First, the FILLER needed to be a CHAR so

LOAD DATA
INFILE 'dtf.dat'
INTO TABLE dba_1.testa
FIELDS TERMINATED BY ',' (stuff1 CHAR(10),
ext_fname FILLER CHAR(20),
stuff2 LOBFILE(ext_fname) TERMINATED BY EOF)

Second, there needs to be a comma at the end of every row in the INFILE.

ABCD,Stuff.gif,

Then it worked Received on Wed Apr 12 2000 - 00:00:00 CDT