How do you display blob data type images from Oracle 10g into Cognos 8.2?

[ahladia]

Hi there,
I am trying to display Oracle blob images that are stored in a table into Cognos 8.2. I have read that the solution to this problem is to use Java in FM. Is this true or I am complicating the situation?

Thanks

[MFGF]

Hi,

This was all I could find on the topic,  but it's not very detailed unfortunately.  I haven't seen Darek on here for a while either...

MF.

[JoshuaRodd]

I had to the same thing. I tried using Mashup Services to retrieve the image from a web service I wrote myself, which works OK, but results in the image not being in PDFs, etc.

BTW we are using Oracle 10g and Cognos 8.4, which is why we have MS. I'm surprised there isn't a simple facility to embed a BLOB. I certainly don't want to start writing a bunch of custom Java code.

[FM]

this is the way to do it:

http://www-01.ibm.com/support/docview.wss?uid=swg21344133

[ahladia]

Hi there,
thanks for all the information that you provided me. The last hyperlink is for CLOB and not for an image based BLOB. I tried to use this idea for the BLOB but didnot work. Any other ideas, please? The images will display in the Java Eclipse Birt but in Cognos report studio..

Dimos