This content has been marked as final. Show 1 reply
Does anyone know if this is possible to do straight from Oracle and if so, what libraries I should be looking at?XSLT can do the job nicely.
Oracle offers some interfaces to apply an XSLT stylesheet to any XMLType instance :
- XMLTransform function
- XMLType's transform method (now deprecated)
- DBMS_XSLPROCESSOR package
You can look those up in the documentation for your version to see how to use them :
Since you've started with DBMS_XMLGEN (wouldn't have been my first choice), you can use the setXSLT procedure to associate an XSLT stylesheet to the context so that the transformation is performed on-the-fly.
You'll find tons of XSLT examples about converting XML to HTML on the Internet.
Here's one I wrote last year to answer a similar question :