Uploading and Download images to DB from a form

From: Jalo <jepardo_at_intrastore.cdc.com>
Date: 2000/01/31
Message-ID: <8741m3$ehq$1@talia.mad.ttd.net>#1/1

Hi everybody:

I`ve done an aplicattion to upload an image to the DB. the source is like this

<HTML>
..

<FORM enctype="multipart/form-data" action="/app/upload" method=POST>
<INPUT type="file" name="FILE">
</FORM>

..
..

the PL/SQL that recive´s the data is
create or replace procedure upload (FILE in varchar) begin

INSERT into mytable values (FILE)
...

end;

till here there isn´t any problem, the image is stored correctly in the DB, the cuestion is how can i download the image as part of an HTML page?? when i excute a PL/SQL like this

...

begin

htp.htmlopen()
htp.htp.headopen();
...
..

htp.download_file(FILE);

end;

the image is downloaded but as a entire page, not as a part of the HTML page, i mean, i cant introduce this image into a table or any part of an HTML document...

can anybody help me??? Received on Mon Jan 31 2000 - 00:00:00 CST