getting the "encoding" in generated xml
527177Aug 21 2006 — edited Dec 8 2006okay i am using something like:
SELECT SYS_XMLAGG(attribxml,sys.xmlgenformatType.createFormat('hello')).getStringVal() into finalresult FROM temp
everything works fine.i get the xml looking something like
<?xml version="1.0"?>
<hello>
..
..
</hello>
The problem is i want something like
<?xml version="1.0" encoding="UTF-8"?>
at the start of the xml
( yes the encoding tag)
is this possible? i searched the forum but couldnt find something related to this.
thanks in advance
---------
i hate mondays.