Our client has a similar requirement to this article:
We wish to give our client a HTML editor, so that they can format their text. This text is then converted to XML with the tags un-escaped. Within Altova Stylevision, we have created a template which converts the HTML to XSL-FO, so that the format is recognised. The XSL template is then uploaded back to APEX, and a PDF is generated using ORDS.
For this to work, the HTML cannot be escaped from Oracle APEX. I can't seem to get the CDATA function to work.
Can someone please provide advice.
You may need to generate the XML data manually using XML SQL commands.
I went into details of what to do with it afterwards here:
If your layout as an "&" symbol in it, you may need to upgrade to 4.2.5.
I've done a lot of research regarding this. I'm leaving out the details of the problems I've discovered until I have filed with Support.
PS - Try upgrading to 4.2.5 before you do that hard, manual process