Need to upload and download PDF using Oracloe Forms

by Sam
(Tri)

Hi All


There is a new requirement for my application based on Oracle forms 10g, users need to to upload and download PDF documents into database using the forms 10g application.

The document could be save as BLOB, but I did not find any equivilant data type in Forms

Looking for your advises.

Regards
Sam

This isn't something that we've done but Forms 10g should be able to use BLOBs via PL/SQL if nothing else as BLOB is a native database type from Oracle 10g onwards. As for uploading and downloading to and from the database, UTL_FILE can do that but only to the and from the database server itself not from a client.

So, if you need to upload from and download to the client what is the solution? A quick search came up with something that looks as if it may work. An enhanced HTML browser bean allows upload and download of files from the client using the Webutil FILE_TRANSFERT package.

The code for the Java Bean is available form SourceForge at http://fdtool.free.fr/forms-pjc-bean/eHTMLBrowser/EnhancedHTMLBrowser.java. There is some information about usage at http://forms.pjc.bean.over-blog.com/article-5029633.html and at http://sheikyerbouti.developpez.com/webutil-docs/Webutil_store_edit_docs.htm.

This is not something we've tested so we are not recommending it and we can't take any responsibility for using it. If you decide to use it try it on a development system first (preferably stand alone).

Click here to post comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Oracle Questions.