Re: Upload file
Date: Fri, 10 Mar 2000 20:25:13 GMT
Message-ID: <8abln3$vss$1_at_nnrp1.deja.com>
[Quoted] LOB objects can only be processed in chunks of 32K, so you need to write a loop to read or write until all of it is consumed.
In article <i5Jv4.34$OX1.637_at_wormhole.dimensional.com>,
"Bill Coulam" <bcoulam_at_DELETECAPSusa.net> wrote:
> Not sure why you're having trouble with files greater than 32K. We
had to
> get a patch for 4.0.8.1 for file uploading to start working again
(using OAS
> 4's content services). To get it into a blob column, I just had to
read the
> 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
> column. However, TO_LOB, isn't recognized by 8.1.5 PL/SQL engine; you
have
> to use dynamic SQL (I used native dynamic SQL) to call upon that
function.
>
> best of luck,
> - 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.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Mar 10 2000 - 21:25:13 CET