Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

CLOB in XML giving unhandeled junk characters

Question
32
Views
0
Comments

Summary

CLOB in XML giving unhandeled junk characters

Content

Hi,

I am working on quotation module. Reports picking the data from CLOB datatype and showing in pdf ouput through xml publisher. Due to clob data type  xml is showing in junk characters which we cannot handle. apart from special characters xml tags are  showing like <B>,<P>,<STRONG>,</B>,</P>,</STRONG> etc. etc.

Even converted CLOB to varchar2 but still problem exists. for you information attached document how clob columns looks like .

PLease have a look into xml file where you can all types of junk and xml tags.

Kindly provide me the solution if anyone know how to handle  clob column which is having huge text  and want to print in pdf through  rtf template from xml publisher.

Regards