Hi, how to download a file from the blob field in the client? can be an example? api_application.filedoschnload - no success.
asked 21 Nov '12, 04:57
Formspider does not provide an out of the box solution to download a document stored in the db. There is already a feature request created in our issue tracking system about this issue, we are planning to implement it for the version 1.3.
In the meantime, you can implement a servlet that retrieves the blob from the db and provide download functionality. Then you can use this servlet through api_application.run API.
Best Regards, Ibrahim
answered 21 Nov '12, 05:42
Ibrahim Sand... ♦♦
I had the same problem as you. What I did to solve it:
1)Installed Oracle HTTP Server 11g. You can install it on any machine that has access to the database, but I prefer to have everything on 1 machine. So install it on the same machine as Oracle & Formspider.
2)Add a new entry to dads.conf located in <installdir>/ohs/conf/mod_plsql. This entry creates a new virtual directory and set the landing procedure to be the one that will download the document
3)In oracle create a procedure to download the document using wpg_docload.download_file.
4)In formspider use api_application.fileDownload pointing to the dad/procedure you created in step 2.
Basically you follow the same path as in APEX. It is not so complicated, if you already done something similar in APEX.
If you need more help, I can upload a zip file with the solution for you.
answered 21 Nov '12, 13:26