How to display content stored in BLOB to oracle forms [message #679361] |
Tue, 25 February 2020 10:50 |
|
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.
|
|
|