Whitespace is not allowed at this location. Error processing resource

SANDEEP MULLANGI · Jan 6, 2017 8:00AM

Summary

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 · Jan 9, 2017 8:00AM

Thank You

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

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

User910243567 · Jan 9, 2017 8:00AM

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