Hi everybody

I want to query oracle and get the result as xml that I can work with in my C++ Builder application. I have tried to use the XML SQL utility from within a pl/sql function that returns a clob. It works but is this the best way to do it? I also want to be able to transform the xml output with a xsl stylesheet before it's returned. Does anybody know how to do that from within a pl/sql function?

Any help or comments are appreciated.


/martin