Re: Storing IMAGES in an ORACLE DATABASE

>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.

Store the filenames. Just write a program that will initially scan the filenames into the database. You may as well use the value of operating system stored files instead of bogging down your database. This will also allow you to do operating system backups of the graphics files and not burden your database backup with tons of extra storage requirements. The only down side is programming your screens to perform the OLE automation, which should not be a major problem.

Rick Baker, Financials & DBA
The Vincam Group, Inc. Received on Thu Jun 13 1996 - 00:00:00 CEST