Oracle Forms (MOSC)

MOSC Banner

How to view blobs lying in a remote db accessible only via dblink

edited Feb 23, 2012 1:29PM in Oracle Forms (MOSC) 2 commentsAnswered
Hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center