Blob data support in cognos

[uyravikumar]

In Frame work manager it is providing the the data type of the query item for BLOB. but i am unable to utilize it ...

My Requirement is Placing the documents into BLOB column of Oracle database. Now I want to Display the documents which are placed in BLOB column as a report with content and format.

The documents might be Word/Excel/PDF/Image.

Please suggests me is it possible through the Cognos.

Thanks in Advance
Ravi.

[COGNOiSe administrator]

With a pinch of java code, sure. You have to extract the BLOB and provide correct MIME type. Cognos will not do that for you.

[uyravikumar]

Hi,

i tried changing the MIME settings in web.XML of cognos install directory and build the war file and deployed into the app server.

I am not sure where i have to write the Java code,
is it in HTML object which is placed as calculated item in list object ?

I have PDF documents stored in Oracle BLOB.
I want to show a normal list coming from normal tables and then documents contents stored in BLOB.

Please provide the Java code to do this.


Its a little bit urgent... i was eagerly waiting to see the output.

Thanks in advance
Ravi.

[COGNOiSe administrator]

Yes, you will have to use the HTMLItem element. As for the code, try to Google BLOB JAVA PDF.

[pt@tbcg]

Hi,

i tried changing the MIME settings in web.XML of cognos install directory and build the war file and deployed into the app server.

I am not sure where i have to write the Java code,
is it in HTML object which is placed as calculated item in list object ?

I have PDF documents stored in Oracle BLOB.
I want to show a normal list coming from normal tables and then documents contents stored in BLOB.

Please provide the Java code to do this.


Its a little bit urgent... i was eagerly waiting to see the output.

Thanks in advance
Ravi.

Did you get this working?  If yes, can you share the solution (ie. the Java code)?