What is the best way to convert Oracle903 ResultSet to XML ?

[rs207]

I'n using oracle.xml.sql.query.OracleXMLQuery and then returning the
xml string using getXMLString method
Is there a better way to do that?

Thanks
rs

 

[Malte]

I'n using oracle.xml.sql.query.OracleXMLQuery and then returning the
xml string using getXMLString method
Is there a better way to do that?

Thanks
rs

I feel it is quicker and more portable to use a stored procedure that
generates the XML, then use a CallableStatement to call the sp and
return the xml.

 

[rs207]

Thanks for the quick response:
I'm running a stored procedure using prepareCall,
read the ResultSet using registerOutParameter(2,OracleTypes.CURSOR) and
converting to XML using: new OracleXMLQuery(con,rs)

Am i using the best way ???