Generating Microsoft XML Spreadsheet (XMLSS) schema format output
I am trying to generate Microsoft XML Spreadsheet (XMLSS) format output from a PL/SQL procedure.
Then I can create a web page using OWA that opens a Microsoft Office Web spreadsheet or pivottable component which will read the XMLSS output from an Oracle Web server.
I can code a PL/SQL procedure to create this type of output, but I am wondering if Oracle has an XML tool, or a recommended approach, to do this?
The XML-SQL Utility for PL/SQL will generate XML, but not in the XMLSS format.
Thank you.