Output "<" instead of "& lt;" and ">" instead of "& gt;" using XMLELEMENT
441307Jul 18 2005 — edited Jul 19 2005I have a procedure generating an xml file from a sql query.
I have this instruction:
xmlelement
("Model_ID", '<![CDATA[' ||'U252'||C.SEGMENT1||']]>')
But when I run it, I get:
<Model_ID>& lt;![CDATA[U25218]]& gt;</Model_ID>
And then I need to replace the "& lt;" and "& gt;" for "<" and ">" manually using Notepad in order to make the file useful.
Is there any way to escape this characters to get the correct output right from the procedure?
(I inserted a blank space after the ampersands to prevent this HTML editor from converting the code to the symbols)
Thanks.