Whitespace is not allowed at this location. Error processing resource

Question

Summary

Content

I've a data in Database Tables.  Like this : Oper & Maint

When I use REPLACE (:v_value, '&', ';') command It works fine..

If I do not use the REPLACE command It is giving me WhiteSpace error. In the Report they want to display as it was in Database.

Im writing my code in XML Publisher using PL/SQL

Version:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

SANDEEP MULLANGI · Answer

Thank You

I use this code in XML PL/SQL ..It worked

Code: REPLACE(v_value, '&', '&'||'amp;');

User910243567 · Answer

Try using DBMS_XMLGEN.CONVERT() function on the column, It will convert data to canonical XML format.

https://blogs.oracle.com/manojmadhusoodanan/entry/bi_publisher_formatting_issues