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

Alexandr's gravatar image

accept rate: 0%

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


answered 21 Nov '12, 05:42

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
accept rate: 25%

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.



answered 21 Nov '12, 13:26

Vlisidis%20Akis's gravatar image

Vlisidis Akis
accept rate: 5%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 21 Nov '12, 04:57

Seen: 2,707 times

Last updated: 22 Nov '12, 20:29

© Copyright Gerger 2017