seeing is beleiving or is it pic is worth a 1000 words
there are more than one way to store lob data
a) you can use dbms_lob package
b) you can use oci ( thsi is the fasyest way to load data)
c) or you could use the good ol sql loadeer yeah you bet baby you can do it with sql loader heres an example of how i did it with my databse on linux 6.2 running oracle 8.1.6 r2 at my home. interested to know read on
Using SQL*Loader to Load Rich Data
SQL*Loader can load whole files into internal LOBs. For example, let's add one column called MY_RESUME to the recipes table.
ALTER TABLE RESUMES
ADD (MY_RESUME BLOB DEFAULT EMPTY_BLOB());
The MY_RESUME column will hold Adobe Acrobat PDF files that contain the most recent update of my resume. You can bulk load existing resumes into the database with SQL*Loader. In this example, a file named resumess.dat, containing data targeted for insertion into the RESUMES table.
1,HRISHI' s resume
When loading the data, you use a SQL*Loader control file similar to this example:
APPEND INTO TABLE RESUMES
FIELDS TERMINATED BY ','
(name, external_filename FILLER,
TERMINATED BY EOF