Re: How to store images/pictures in Database?e

Venkat K Reddy wrote:
>
> Hi! Could someone please tell me how to store images, multimedia in the
> database or atleast point me to some source of information. I would
> like to store bmp, avi etc in the database and I am using V 7.3.3.

I have written a little forms application wich stores graphics in a ORACLE database. In form 4.5 you can use the procedure READ_IMAGE_FILE(file_name,file_type,item_name) and after you fetched it from the OS-specifiec-file you can store it in the database. You can use a RAW column for the graphic in the table you wil use for storing the graphic-file. The variables which the procedure READ_IMAGE_FILE uses are:

file_name: os-specific filename including directory & extension file_type: graphic file-type you want to fetch : ORACLE knows TIFF, JFIF, BMP, PICT & GIF
item_name: item_name on the form you want to read the image into

I've never searched for a method to store AVI in a ORACLE database. But in a RAW column you can store almost anything. A source of information could be FORMS REFERENCE MANUAL.

                Good luck, with friendly regards,

-- 
                                               G.R. van der Ploeg
                                              (G.R.v.d.Ploeg_at_imn.nl)
                                               IMN NV Zeist, Holland
                                               ORACLE DBA & Developer