XML Query mit Union

[Lulli]

Hi,

kann mir vielleicht jemand bei einer XML query für eine Oracle DB helfen?

Brauche XML code von der folgenden query:
select * from dba_stmt_audit_opts union select * from dba_priv_audit_opts;

xml schema ist:
<xsd:complexType name="sec_tauditing">
xsd:sequence
<xsd:element name="sec_audit" type="xsd:string" maxOccurs="unbounded" />
</xsd:sequence>
<xsd:attribute name="sec_audit_option" type="xsd:string" use="required" />
<xsd:attribute name="sec_auditing_user_name" type="xsd:string" use="required" />
<xsd:attribute name="sec_auditing_proxy" type="xsd:string"/>
<xsd:attribute name="sec_auditing_success" type="xsd:string" use="required" />
<xsd:attribute name="sec_auditing_failure" type="xsd:string" use="required" />
</xsd:complexType>

Nachfolgend mein Versuch der mir aber einen Fehler bringt: ora-01427: single row subquery returns more than one row

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
/

Irgendjemand mit einer Idee wie ich das hinbekommen könnte?

Thanks!