SQL & PL/SQL

Hi,

I am using query this way to generate xml output .

  SELECT

        xmlelement("date", xmlattributes(TO_CHAR(sysdate,'YYYY-MM-DD HH24:MI:SS') as "update",  x.count as "count" ),

           xmlagg(

              xmlelement("xyz", xmlattributes( x.last_update as "last_update"),

                    xmlforest(description1, description2 ........).getclobval()  AS XML_STR

Now my issue is that this returning value of xml_str put up some html encoding .

For example if i have & into description it's result into &.  My need is that i have in description1 to be & where as value have into description2 as it is.

I tried DBMS_XMLGEN.CONVERT but not worked for me.

Can you please recommend the best way to achieve this?

Thank You.