Re: Storing IMAGES in an ORACLE DATABASE

From: Marcus Williford <marcus_at_eola.ao.net>
Date: 1996/06/11
Message-ID: <4pkbht$naj_at_news.ao.net>#1/1


Bob Stewart (bob_at_latcost1.alaao.ats.eds.com) wrote:

: 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 am currently researching exactly what you described. First look at the proc example files, $ORACLE_HOME/precomp/proc/demos/sample4.pc. It does binary loading and unloading into the long raw field. I modified that to also be a cgi-bin and call it to deliver my images via internet when I choose. if you need further help with this subject, email me and we can share knowledge.

thanks,
marcus_at_ao.net Received on Tue Jun 11 1996 - 00:00:00 CEST

Original text of this message