Re: To Upload and download LOBs into an Oracle 8.x database using the OAS

The new OAS 4.0 does do the upload and download of files into the database. But there is a limit of 8 Mb (approx). Apparently, this is a Spyglass listener limit. The upload and download work for files and images smaller than 8 Mb. The problem is with files larger than that. This is documented in the OAS developer's guide (chapter 7).

I am trying to avoid writing a CGI script if possible. There was a cartridge provided at one of the Oracle sites which did the upload and download of blobs (OWA replacement cartridge) but unfortunately Oracle is no longer supporting the cartridge.

KN
kasibhatla.n_at_pg.com
John M. Heaton wrote:
>
> If you're talking about uploading a file from a client using a web browser,
> the only way I know is to use CGI. What I did is use a Perl script to
> retreive
> the file from the client and put it in a directory on the server. Then I
> used a
> stored procedure to suck the file into the database.
>
> "Narasimha Kasibhatla (KN)" wrote:
>
> > Hello:
> > I am trying to upload and download LOBs into the database using the OAS.
> > The OAS developers guide seems to indicate that uploading and
> > downloading the files using the OAS 4.0 is possible. Has anyone done
> > this? Is it possible to upload and download lobs into the database
> > without using some sort of a CGI?
> >
> > Thanks,
> >
> > Narasimha
Received on Wed Jun 02 1999 - 10:18:16 CDT