BLOB, CLOB, RAW and Looooong

The data engine introduced some new support for data types other than the normal varchar, date and number formats in 10.1.3.3. We now have support for the long, raw, clob and blob formats - and you do not have to do anything in the data template to handle these formats.
We auto detect for BLOBs and if it contains an image we will 'base64' encode it and drop that into the XML output so you can then render the image in the output.
If it has text we will return the
escaped format of the text and we only support UTF-8
encoded output. Other BLOB formats we leave alone.
There is an issue for CLOBs around a maximum size retrieved by a data template, that has been addressed in 10.1.3.3.1.

The above applies to 'data template' based reports. If you are using straight SQL things are a little more limited. We have BLOB and CLOB support and the auto detect for images is working but we do not have support for RAW and LONG column types at the moment - we're looking into that for a future release.

Comments:

Hi Tim I have tested simple data template against 10.1.3.3 . The template contains XMLTYPE retreived as Clob, and it contains few more fields in additional group, the fields are mapped/groupped in dataStructure section of template. As a result I could not get correct xml returned from Clob, but instead escaped text. It is the same result as with versions 5.6.3. Then what do you mean - "We now have support for clob" ? (I tried to rase a SR for this, but support do not recognize an issue here) Best Regards Victor Dusanyuk, Dell

Posted by Victor Dusanyuk on December 19, 2007 at 05:30 AM MST #

When I select more than one image, the data template shows the same value for all images. How can I make this work?

Posted by Harold on October 23, 2009 at 07:12 AM MDT #

Hi Harold, I also faced this issue, have you got any solution for this? If yes, could you mind to share to me? ==== Harold: When I select more than one image, the data template shows the same value for all images. How can I make this work? Thanks, Michael

Posted by Michael on January 25, 2010 at 02:02 PM MST #

"michael_linfree@hotmail.com" is my email address. Thanks a lot! Michael

Posted by Michael on January 25, 2010 at 02:03 PM MST #

Hi tim, Is it possible to print the BLOB of type Word Document in XML Publisher Report.

Posted by Mahesh on April 25, 2010 at 09:00 PM MDT #

Hi Tim, Even I have the same Question. Does XML Publisher Support printing of a BLOB type Word Document?

Posted by Sanjana on May 19, 2010 at 09:58 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today