Export query result if this is XML output

[Pierre Maas]

To all,

When i do export the query results from a clob with xml nodes in then the "" signs are replaced by "lt;" and "gt;" (with a & in front) characters in notepad. How can i change these ?

thanks in advance
pjmaas

 

[Marco Kalter]

I assume you mean < and > in the data? This has to be encoded as lt; and gt; otherwise the XML would be incorrect.

 

[Pierre Maas]

Thanks for reply.
Indeed I mean the < and > sign. If you open this exported data in Internet Explorer you see the correct data. But, this exported data I want to use this as input for Stylus Studio and then you see the replacements of the signs < and > . Ok, i can do find and replace to solve this, or, do you have somewhere in PLD an option to choose for this problem ?

regards
pjmaas

 

[Marco Kalter]

I can't immediately think of a workaround in PL/SQL Develoepr, other than creating a PL/SQL function that would perform this replacement, and use this function to create a result set for export.