Re: storing images thru forms

Hello,

In order to stored image files in the database, you need to store them in a LONG RAW field.

Create a new form and base it on the table that has the long raw. Use the READ_IMAGE_ITEM builtin to read in a jpg to the long raw base table item. Then commit it to the db. Viola, it's in the db.

You can create a When-Button-Pressed trigger that looks something like this to do it:

Begin

   Read_Image_File('photo.jpg', 'JPG', 'block.item'); End;

Press the button, and save the record to the db. Check out the on-line help for more info.

Mark Freudenberg   

On Wed, 26 Mar 1997 21:33:54 +0100, Frank Huijbreghs <frankhu_at_worldaccess.nl> wrote:

>KWIATKOWSKI LARRY wrote:
>
>> I want to store a jpeg or gif file in the oracle database. we are
>> running 7.3. does anyone have an example of a form that loads and
>> retreives this file type. thanks in advance
>
>I've got the same question.
>Please let me know if you've got the answer.
>
>Greetings from The Netherlands
>F. Huijbreghs
>frankhu_at_worldaccess.nl
Received on Sat Mar 29 1997 - 00:00:00 CET