How to display content stored in BLOB to oracle forms [message #679361] |
Tue, 25 February 2020 10:50 |
![](http://www.gravatar.com/avatar/13c19d71a6993dc40f9ffc5061f72e9b?s=64&d=mm&r=g) |
Shiv93
Messages: 34 Registered: September 2019
|
Member |
|
|
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.
|
|
|