Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert XML to HTML

932936Oct 29 2012 — edited Oct 29 2012
All,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2012
Added on Oct 29 2012
1 comment
926 views