Re: Storing IMAGES in an ORACLE DATABASE

Andrew Robb <arobb_at_kilo.uws.edu.au> wrote:

>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 don't know if a small Forms 4.5 app. is an option, but here's how I did it:

-The images (scanned letters and adds) are stored in ONE directory (say C:\scans);
-I made a small Forms 4.5 program that issues a DOS command DIR C:\SCANS\*.JPG /B > names.dir - this gives a list of only the filenames without sizes etc.
Using the TEXT_IO package I scan the file names.dir and use the load_image_file procedure to load the files one by one into a long raw column.

The reason why I did it this way is simple: I can't do C and this is a very simple app, and it works...
Maybe it's of use. Received on Sun Jun 23 1996 - 00:00:00 CEST