How to view blobs lying in a remote db accessible only via dblink
I have a form in 10.1.2 that displays a list of documents (blobs) fetched from a view created over a dblink. The user wants to click on the links on each document in the list and be able to view the document. But the document is lying in a remote db. How to view this document.
I have a java servlet developed in 10.1.3.2 Jdeveloper. This servlet on its own takes POST parameter, i.e, doc_blob_id and dwonload the PDF on a browser.
I tried UTL_HTTP , setting the parameter as POST and calling the URL. The servlet gets called, because some SOP messages are seen on the console. But no browser pops up. Also I don't get the doc_blob_id I sent via POST.