Convert XML to HTML
932936Oct 29 2012 — edited Oct 29 2012All,
Version Info:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
My question:
I have a query that I converted to XML using DBMS_XMLGEN. Right now the result is stored as CLOB, but I can store it as XMLTYPE if it will be easier for what I'm trying to do.
I would like to take my XML documentation and convert it to an HTML Table for the purposes of including this inside of an e-mail (using UTL_MAIL). I can already create an HTML table manually if I explicitly name each column and do a lot of crud, but ideally I was hoping I could leverage XML somehow to make these kinds of reports easier to send to my end-users.
Does anyone know if this is possible to do straight from Oracle and if so, what libraries I should be looking at?
Thanks.