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.
« 10.1.3.3.1 is a pointed release Main | Editing XML? »
BLOB, CLOB, RAW and Looooong
About
An almost daily dose of Publisher. Covering all the flavors, from EBS to Enterprise. Tips, tricks, walkthroughs and 'how-tos' from building templates to using web services. Everything you need to know about Publisher, coming at you from 7000 ft, in the foothills of the Rockies, Colorado
Comments (2)
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 | December 19, 2007 1:30 PM
Posted on December 19, 2007 13:30
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 | October 23, 2009 1:12 PM
Posted on October 23, 2009 13:12