Home » Developer & Programmer » Forms » How to display content stored in BLOB to oracle forms (Oracle12c)
How to display content stored in BLOB to oracle forms [message #679361] Tue, 25 February 2020 10:50
Messages: 34
Registered: September 2019
Hi Everyone,

My requirement is to display a report in oracle forms.So I have an API url which I'm invoking from my plsql package..
I pass the necessary inputs for the API and it sends me back a response which is actually containing my report data to be displayed..Now the response from the Api seems to be in octet stream, so I saved it my in DB under one table as a BLOB. Now the problem is how do I get the BLOB content to be displayed in my oracle forms.

Also I tried other option like instead of saving it's as BLOB I saved it in a CLOB variable and when I try to display it in the screen through forms it's showing me a garbage content.

So folks pls suggest me a good way to display my report by invoking a webservice.
Previous Topic: Capturing photo from webcam in oracle forms
Next Topic: oracle.forms.webutil.file.filefunctions bean not found.webutil_file
Goto Forum:

Current Time: Sat Jan 23 19:01:32 CST 2021