I am building a kind of document management app. I have in a table documents stored as blobs. These documents are mostly pdf, doc, xls and dwf (autodesk drawing) format. I want to have a controlled way (see security and audit) to have access to the documents. How can I do it using formspider API?
A workaround could be to serve them by using htp.p but that means that the databse should be exposed to the net.
asked 30 Sep '12, 13:13
Hi Michiel, This is the same exact code I already use in APEX, but it is not working in formspider. It looks like oracle is serving the data, but they are not going through tomcat to the client. In fact when I click the download button, that calls this procedure nothing happens in the client. I checked that the procedure is called by putting a popupmesssage. I'm thinking to pass the call to apache and let apache serve the file through mod_plsql but is not an elegant solution.
(A hint: just before owa_util.mime_header put a owa.num_cgi_vars := 0; to overcomme an oracle bug).
answered 01 Oct '12, 02:39
You can download a file existing in a specific URL using
I have created a feature request in our issue tracking system about this case and put it to the candidate list for version 1.3. I will keep this post updated.
Best Regards, Ibrahim
answered 01 Oct '12, 03:08
Ibrahim Sand... ♦♦