COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: ahladia on 16 Jun 2010 01:07:56 PM

Title: How do you display blob data type images from Oracle 10g into Cognos 8.2?
Post by: ahladia on 16 Jun 2010 01:07:56 PM
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
Title: Re: How do you display blob data type images from Oracle 10g into Cognos 8.2?
Post by: MFGF on 17 Jun 2010 05:11:59 AM
Hi,

This (http://www.cognoise.com/community/index.php?topic=2747.0) 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.
Title: Re: How do you display blob data type images from Oracle 10g into Cognos 8.2?
Post by: JoshuaRodd on 12 Jul 2010 11:10:59 AM
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.
Title: Re: How do you display blob data type images from Oracle 10g into Cognos 8.2?
Post by: FM on 03 Sep 2010 07:02:28 PM
this is the way to do it:

http://www-01.ibm.com/support/docview.wss?uid=swg21344133 (http://www-01.ibm.com/support/docview.wss?uid=swg21344133)
Title: Re: How do you display blob data type images from Oracle 10g into Cognos 8.2?
Post by: ahladia on 13 Sep 2010 07:36:19 AM
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