Turning a Oracle Recordset into XML

[Dynapen]

Here's the problem I am having. I need to have Oracle build me a recordset off of a SQL statment I am passing, but to pass me the recordset back as a XML document. I believe that it can be done, but I can't find a single example of how. Without that, I have to set my webserver to build a XML doc out of the recordset, and then pass it on, so I am doubling my work on the webserver.

Does anyone know how to do this, or of a good source to use to find out for sure? The money's gone, the brain is shot.....but the liquor we still got.

 

[sem]

Try to use xmlgen.getxml function.

 

[Dynapen]

Where is this function located. On the DB Side? Applicaiton Server Side?

And is there anywhere I can get some info on it? The money's gone, the brain is shot.....but the liquor we still got.

 

[sem]

You may find all the info in oracle manuals. XMLGEN is server side pl/sql package and GETXML is a function, that accepts select statement as a string (varchar2) and returns the result XML as CLOB. The package contains also a number of useful functions to format results and call DML commands using XML.

 

[absolute]

If you haven't done already , Down Load the XDK from the Oracle site, install it. There is a test to confirm if the XDK installed correctly.
You will get dbms_xmlquery.getxml() , which takes SQL and output an XML.
For the DTD you will have to use dbms_xmlquery.getdtd('SQL Query')
HTH