How to upload a file using Web and PL/SQL?

From: David D. Anderson <David.D.Anderson_at_wrtfac.day.cdc.com>
Date: Wed, 15 Jul 1998 17:06:12 -0400
Message-ID: <35AD19C4.BA94ACC3@wrtfac.day.cdc.com>

All,

I'm trying to find sample PL/SQL code to allow me to store a file uploade from the browser using an HTML form input tag of type file (<INPUT TYPE=FILE NAME=UPFILE>).

All the Oracle Web Application Server 3.0 books that I have mention that this is possible, but don't give any examples.

When I submit my html form, I get the name of the file back from my PL/SQL script instead of the actual file content, unless I use the multipart/form-data encoding type and then I get an error...

Here is what the HTML looks like.
<HTML>
<BODY>
<form method=post action="http://hostname.com:8999/dtprracc/plsql/adm
in.createIssuePage" enctype="multipart/form-data"> File:</td><td><input name="p_issue_page" type="file" size=64 maxl ength=128 align=left>
<input type="SUBMIT" value="Submit" align=left>
</form>
</BODY>
</HTML>

It seems like a get an error automatically when I use th e multipart/form-data encoding. Do I need to do anything special to accept this type of encoding from PL/SQL?

I just want the content of my uploaded file to end up in a varchar2 variable that I will later store in the database...

Any help would be appreciated.

Sincerely,
Dave Anderson.

--
David D. Anderson
David.D.Anderson_at_cdc.com
Control Data Systems
Dayton Ohio office Received on Wed Jul 15 1998 - 16:06:12 CDT