XML Query mit Union

[Lulli]

Hallo,

also meinst du?

SELECT tab.\* from (select xmlelement ("sec\_auditing",  
xmlagg((  
		select xmlelement("sec\_audit",  
				  xmlattributes (audit\_option as "sec\_audit\_option", user\_name AS "sec\_auditing\_user\_name", proxy\_name AS "sec\_auditing\_proxy", success AS "sec\_auditing\_success", failure AS "sec\_auditing\_failure"))  
FROM dba\_stmt\_audit\_opts  
union all  
		select xmlelement("sec\_audit",  
				  xmlattributes (privilege as "sec\_audit\_option", user\_name AS "sec\_auditing\_user\_name", proxy\_name AS "sec\_auditing\_proxy", success AS "sec\_auditing\_success", failure AS "sec\_auditing\_failure"))  
from dba\_priv\_audit\_opts))) from dual) tab  

/

Das bringt mir den gleichen Fehler. Auch das weglassen des AS beim zweiten teil von UNION ändert leider nichts. Sonst noch eine Idee oder habe ich deinen Ansatz falsch umgesetzt?

Danke und Gruß,

Lulli