This class makes it very easy, almost trivial, to convert SQL query results into XML, but a major disadvantage of OracleXMLQuery is that it is a proprietary solution.

An unrelated program, called DB2XML.asp (available here) shows how to perform such conversions using .Net code. Stylus Studio is a commercial offering that uses ADO to convert between SQL and XML ...