Re: Upload file
Date: 2000/03/02
Message-ID: <i5Jv4.34$OX1.637_at_wormhole.dimensional.com>#1/1
[Quoted] Not sure why you're having trouble with files greater than 32K. We had to [Quoted] get a patch for 4.0.8.1 for file uploading to start working again (using OAS [Quoted] 4's content services). To get it into a blob column, I just had to read the [Quoted] websys.ows_content table and use the 8i built-in function, TO_LOB, to convert the column during an insert into my own table with a CLOB and BLOB [Quoted] column. However, TO_LOB, isn't recognized by 8.1.5 PL/SQL engine; you have [Quoted] to use dynamic SQL (I used native dynamic SQL) to call upon that function.
best of luck,
[Quoted] - bill c.
<yaguimanboy_at_my-deja.com> wrote in message
news:89lrpu$h0q$1_at_nnrp1.deja.com...
> Hi, I want to upload a file form a web page and store it in a blob
column.
> How can I do that?. I write this html:
>
> <html> <head> <title>File Upload></title> </head> <body> <form
> enctype="multipart/form-data" action="/app/prueba_upload.upload"
> method="POST"> <p>Archivo a subir <input type="file" name="file"> <p>
<input
> type="submit"> </form> </body> </html>
>
> This works with files less than 32k. We are using Oracle Server 8i and OAS
> 4.0.8.1. We want to do that also with the pl/sql listener that come with
> Webdb.
>
> Thanks for your help
> Martin Andres
> mandres_at_most.com.ar
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Mar 02 2000 - 00:00:00 CET