Hi, how to download a file from the blob field in the client? can be an example? api_application.filedoschnload - no success. |
Hi Alexandr, 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 well, thank you, I will try for another.
(21 Nov '12, 19:32)
Alexandr
|
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. Akis I'm trying to find a separate Oracle HTTP Server 11g, not found. Found only in Middleware | Fusion Middleware 11g, when you install Web Tier tick chose Oracle HTTP Server after installing found folder mod_plsql, launched owaload.sql. Launch a browser to Fusion Middleware Control, but there are no settings OHS, DAD. I would be very happy if you upload a zip file with the solution for me. Thank you.
(21 Nov '12, 19:49)
Alexandr
Thank you very much, I have already configured OHS everything worked through mod_plsql. No need to upload zip file. Thank you.
(22 Nov '12, 20:29)
Alexandr
|