Storing Images on Oracel database

[Fiona]

Hi, I am trying to find out the method for storing images in Oracle database but I can't seem to find any documentations on it.

I have tried Metalink but to no avail - if anyone can give me any help of info, please let me know!

[tamilselvan]

Use BLOB column for the image and store them externally to the database.

[gpsingh]

Search for dbms_lob package , and also OCI with dbms_lob.

[Ispirer]

Hi,

You should use BLOB or BFILE datatype.
If you need in a tool for loading imagies contact me at support@ispirer.com

Best regards, Dmitry

--
[url]http://www.ispirer.com[/url] - Database migration tools and services for Oracle and IBM DB2.

[hrishy]

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
,/u12/oracle/admin/dev/dishimages/1.pdf,
2,Fiona ,/u12/oracle/admin/dev/dishimages/2.pdf,

When loading the data, you use a SQL*Loader control file similar to this example:


LOAD DATA
INFILE 'resumes.dat'
APPEND INTO TABLE RESUMES
FIELDS TERMINATED BY ','
(name, external_filename FILLER,
resumes LOBFILE(external_filename)
TERMINATED BY EOF
)

enjoy
:-)

[Fiona]

Thank you all for your reply and help! Much appreciated! >o<