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.
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.
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.
Yes, you will have to use the HTMLItem element. As for the code, try to Google BLOB JAVA PDF.
Quote from: uyravikumar on 14 Aug 2007 09:41:07 AM
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)?