need sample: insert blob with sqlldr80

Hi,

I am currently for the first time trying to insert blobs (small pdf-files) into a table. Unfortunately it doesn't work so I'd like to see a simple working sample (control file etc.). The table looks like this:

create table bestell_pdf
(vorgangs_nr varchar2(10) unique,

pdf blob);

What I'd like to insert is something like

'01-1234';test.pdf

out of the file data.txt

LOAD DATA
INFILE 'data.txt'
APPEND INTO TABLE bestell_pdf
FIELDS TERMINATED BY ';' TRAILING NULLCOLS
(vorgangs_nr,

  ext_fname FILLER CHAR(80),
  pdf LOBFILE(ext_fname) TERMINATED BY EOF)

does not work...

Stefan Received on Fri Feb 14 2003 - 03:52:02 CST