Re: Storing images or pointers to images - advice please

Hi Carl,

        You can go either way, that is, either store the images or poitners to the images. Personally I prefer to store the images in a flat file and then just store the file name in the data base. (If you have a lot of files and want good performance you should store the full path names and use directory names like "AA", "AB", ... "ZZ").

        The EASIEST way to do it is:

1. store the image as a file
2. invoke a sqlplus script that inserts a row in a lookup table and pass the name of the file as well as the search terms to the script as parameters. (Have the script exit on completion).

Please note that there are many better ways to accomplish your objective, but this can get you started.

regards

Jerry

Carl Sarelius wrote:
>
> Hi,
>
> I'm after some advice re storing of images. I'm new to Oracle, in
> particular, Pers Oracle 8. What I would like to find out is if I can develop
> a db that would also include images, or pointers to image files. I assume I
> can do it, I'm just not sure how.
>
> Advice, or pointers to the right area, would be appreciated.
>
> Thanks
>
> --
> Carl Sarelius
> Carl.Sarelius_at_bigpond.com
> Melbourne, Australia

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group