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: PL/SQL Server Pages, Image File Upload

Re: PL/SQL Server Pages, Image File Upload

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Mon, 15 Apr 2002 10:29:47 +0400
Message-ID: <a9drts$oei$1@babylon.agtel.net>


Not sure how you can limit uploads by MIME type - OWA does not provide a way for this. I think the only way is to delete files of wrong type right away in upload handler procedure (you have one, don't you). As of image processing, I think you need to use ORDImage in your upload handler. As of Accept: HTTP header, it can only be issued by client to notify server of media preferences for response.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Marc" <mstaheli_at_san.rr.com> wrote in message news:9Lku8.38634$VQ2.21336328_at_twister.socal.rr.com...

> I'm experimenting with PSP pages. Everything works fine, but I have a
> problem with file uploads.
>
> what I want to do:
> - user uploads image over the webpage
> - HTTP
> - the mime should be restricted to certain types (e.g. image/gif)
> - the image should be resized automatically to a standard geometry (before
> storing in db) during the upload process
>
> Right now I'm using a table that stores the image in a table with a blob
> data type.
> The upload, retrieval and display to a web page works fine.
> Problems:
> - How can I restrict the mime type? (I tried ACCEPT in form, didn't work.
> Everything goes through).
> - How can I resize the file during the process. Right now, the image is
> saved "as is"
>
> According to the documentation, the mod_plsql takes care of internal
> processing. So I don't know if I'm even able to do what I want with the PSP
> Gateway.
>
> Should I use interMedia with its ORDImage datatype? If yes, how do I upload
> files from the web? Or any other HTTP file upload to the server and simply
> save an url in a table that points to the file on the server? Any good
> advise/examples/approach is greatly appreciated.
>
> I'm running Redhat Linux 7.2 with Oracle 9i.
> This is a simple development box and I do not use an iAS as a middle tier at
> this point (maybe there's the problem...)
>
> Marc
>
>
Received on Mon Apr 15 2002 - 01:29:47 CDT

Original text of this message

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