Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: uyravikumar on 09 Aug 2007 10:22:01 AM

Title: How to display the Document content which is stored in BLOB column in Oracle
Post by: uyravikumar on 09 Aug 2007 10:22:01 AM
Hi

Is it possible to show the content of the Document which is stored in BLOB column in Oracle in Cognos Report.

Welcome your suggestion on this.
Thanks in advance
Ravi.
Title: Re: How to display the Document content which is stored in BLOB column in Oracle
Post by: COGNOiSe administrator on 09 Aug 2007 09:48:18 PM
Not directly.
Title: Re: How to display the Document content which is stored in BLOB column in Oracle
Post by: johnpenna on 14 Aug 2007 06:56:13 AM
Try  using this in framework manager putting "cast_char" in front of query subject then publish.

it worked for me.

cast_char (  [dbo].[APPLIC].[POSTGRAD])
Text only | Text with Images