By Tim Dexter-Oracle on Aug 28, 2009
Im seeing more and more folks wanting to render their stored XHTML in their outputs using BIP. I have written about the 'how' to render in the past but much more recently I have had customers that could not get to the rendering part because the extract was not extracting the XHTML in its raw format.
By raw I mean
'<p>This is a paragraph</p>'.
The data template engine under EBS 11i and R12 was escaping all the angle braces so the above string was coming out as
'& lt;p & gt;This is a paragraph& lt/;p& gt;',
ignore the spaces after the ampersand, just trying to stop the blogging platform from formatting them. Anyhoo, the sub template that converts the XHTML to XSL-FO was not working, its looking for '<p>' not '& lt;p& gt;'
Good news everyone, the dev team have implemented an enhancement for this so that you can get the raw data out. Still not quite out in the wild but look out for patch 8660920 if you are stuck.
All you need to do is change the dataType attribute for the CLOB column to 'xdo:xml' e.g.
<element name="ARTICLE_TEXT" dataType="xdo:xml" value="ARTICLE_TEXT" />
A tiny tiny prize for the person that spotted the Futurama reference?