Our setup is:
APEX : 5.1
DB :12rc
we are using apex listener (ORD)
I am working with a CLOB column that is storing regular text. the text can have these special characters <, > , %, &
the problem is these special characters are getting displayed like this:
%25 for %
%26amp; for &
%26lt; for <
and %26gt; for >
This is a known bug according to the below link and it was supposed to be fixed in 4.2.5. We are using 5.1 so I am not sure why it is not working for me.
https://support.oracle.com/epmos/faces/BugDisplay?_afrLoop=957905848396285&id=18282188&_afrWindowMode=0&_adf.ctrl-state=168vq5zhn3_233
The bug 18282188 has been fixed in Apex 4.2.5 version.
Upgrade the Apex version to 4.2.5 when it is available.
I thought a work around is to wrap the page_item that contain the text with with CDATA before I call the report. But the xml output I am getting looks like this:
<P11_COMMENT>%26lt;[CDATA[Travel %26amp; reimbursement for:]]26gt;</P11_COMMENT>
tried another work around which is to escape special character in xslt file but didn't work either
<xsl:value-of select="/DOCUMENT/P610_CLOB_PDF" disable-output-escaping="yes"/>
Any idea?
Thanks!