Re: Storing IMAGES in an ORACLE DATABASE

Andrew Robb (arobb_at_kilo.uws.edu.au) wrote:
: I need to be able to store ID Photos in and Oracle Database. I am able
: to do this if I load the JPG image using a graphics package, copy it to
: the clipboard and then using power object paste it into the database
: field that I have set up as LONG RAW. This works fine.
 

: The problem I have is that there are some 10,000 of these images and I
: don't particularly want to sit down and cut and paste all of them.
 

: Could someone please give some suggestions as to how I could automate
: this. The images are stored on a PC in many directories. The images are
: all about 15K in size and as I said I have about 10,000 of them. I want
: to load these images along with other data into an Oracle database
: table.
 

: Any and all suggestions are appreciated. Thanks.

I suggest you give up. This is not a good usage of either your time, your customer's time, or the system's time. Instead, store the fileid in your database, and have your application read from disk, which will be MUCH faster.

Good luck.

--
Bob Stewart                     ASE
(310) 335-7152                  Air Transportation Division
bob_at_latcost1.alaao.ats.eds.com

I am definitely NOT speaking for EDS.