Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to upload a file using Web and PL/SQL?

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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 16 Jul 1998 14:47:16 GMT
Message-ID: <35ae11c1.2037209@192.86.155.100>


A copy of this was sent to bonanos_at_yahoo.com (if that email address didn't require changing) On Thu, 16 Jul 1998 06:24:09 GMT, you wrote:

>Hi David
>
>> 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...
>>
>> 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.
>
>WAS 3.0 does not accept the mime type. You have several options,
>You can upgrade to WAS4, you can download the OWA replacement cartridge from
>the govt.us.oracle.com (downloadable utilities) site , or you can install the
>apache web server to handle that functionality.
>

WAS 3.x does accept that ENCODING type (its not a mime type really, the mime types are encoded into the upload, its really a multi-part document like an email with attachements..)

The pl/sql cartridge that comes with OAS3.x does not process that encoding type (only GET and POST).

A user written cartridge can (and does, you refer to it and it works with 1.x, 2.x, 3.x of the webserver)...

Whats in apache that does this any easier then any other webserver? Apache doesn't have a pl/sql cartridge (although you can, and people have, used the owa replacement with apache...)

>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Jul 16 1998 - 09:47:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US