Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

File Upload and Download Procedures in Oracle Database 10g - Upload and download files directly from the database using Database Access Descriptors.



Gaurav said...

This article (File Upload and Download Procedures in Oracle Database 10g) is excellent but I am facing one problem while downloading files:
Nothing happening on doing following
http://myserver:7777/pls/UTILS/document_api.download
Pl tell me the exact way to download files to Gaurav - gogo25@gmail.com .

Tim... said...

Hi.

Provided you have set up your DAD, and you are using your own server name and the correct port in the URL, the browser should display the page correctly, allowing you to download a file.

Please don't ask questions in the comments section. If you need more help, ask a question in the forum.

Cheers

Tim...

remik said...

hi is there a way to make this work on xe ver of oracle im getting 500 error when trying to upload

Tim... said...

Questions in the forum, not in the comments!

I've never tried it because I don't use XE, but I would think it is possible. Probably best to try the XE forum on OTN.

Cheers

Tim...

Kid said...

What about multiple upload files? is possible too? how? thanks.

Scott Wesley said...

I found this handy for specifying filename, used after content-length
htp.p( 'Content-Disposition: filename="' || lc_filename || '"' );

Tim... said...

Hi.

Yes. I use it in my code all the time. Somehow never made it into this article. :)

I've amended this (and a couple of other) articles to include it now.

Thanks for the heads-up! :)

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired