How to print escaped HTML characters in Oracle XML Publisher

xml oracle xml-publisher oracle-xml-publisher oracle-bi

Starting with Oracle 11g you are able to use the PL/SQL package UTL_I18N.

UTL_I18N is a set of services that provides additional globalization functionality for applications.

One of the relevant methods in this context is "UTL_I18N.UNESCAPE_REFERENCE":

SELECT UTL_I18N.UNESCAPE_REFERENCE('ABC < &#38; &#34;') FROM DUAL;

With this you will get an output like: ABC < & "

CodeHunter