Re: PLSQL and upload and download files

Jan

htp.download_file will get any files from the OWS_CONTENT table, which is a table used by OAS to store files (correct me if I'm wrong anyone, please). The WWV_DOCUMENT table is a webdb table. There is no linkage between OWS_CONTENT and WWV_DOCUMENT. Thomas Kyte has a cartridge for OAS available at http://osi.oracle.com/~tkyte/ that does what you are looking for (among other things). However, if you are using webdb, I'm not sure how you can go about it.

Joel

Jan Zak wrote:

> I am trying to create a "file manager" on the web server. I would like
> I-users to upload and download files via it. I am using PLSQL.
>
> For upload I use the standard method (FORM enctype="multipart/form-data"
> action="...")which uploads the file into the database table wwv.document as
> far as I understand (the content can be found in a BLOB field of that
> table).
> When I try to use htp.download_file it does not ask me for the name of the
> file to be stored. It does not download anything from the web server and
> does not issue any error message.
>
> Am I doing it correctly ?
> How can I display or better put the content of the table into a file (I
> want to create a file on the server from the record in that table).
>
> Is this functionality somehow connected with owa_content.list_documents ?
> It does not list any documents even if there are some in the wwv.document
> table.
>
> Can anyone give me some help (resources?) on this issue ?
>
> Thanks a lot
> Jan
Received on Thu May 18 2000 - 00:00:00 CEST