XMLAgg() length limitations of the content?
107233Feb 6 2004 — edited Feb 6 2004Hi all,
Is there a limitation of the content of the XMLAgg() function?
When I do the following query, I've got a result:
SELECT XMLAGG(XMLElement("Company", XMLAttributes(fc.id as "I", fc.short_name as "SN"), fc.name)) as result
FROM fas_companies fc
WHERE fc.analyst_id = p_analyst_id
ORDER BY fc.name;
Is I remove the WHERE-clause, I receave some errors!
<?xml version="1.0" ?>
<!-- 190 -->
<ERROR xsql-timing="190">
oracle.xml.sql.OracleXMLSQLException: '<' cannot appear in attribute value.
</ERROR>