How to get from Database to XML? 1

[rsadasivam]

Hi Everyone,
I am trying to read the variables in an Oracle 8 table and create a XML document. What is the easiest way? Or should I create the XML document and store it as a CLOB variable so that I can read that variable and pass it as the XML document. I need it to have a quick response time since the end user information has to be extracted and passed as an XML document to a vendor site.

Any ideas & suggestions is much appreciated.

Thanks in advance

 

[carp]

This is outlined quite nicely on Metalink in Document #163552.1

 

[rsadasivam]

Thanks, found it to be useful. Have to get the DBA install XML_SQL utility and give it a shot.