Skip to Main Content
Forums

SQL & PL/SQL

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!

Simplest way to apply an XSLT stylesheet and get a new XML doc in PL/SQL?

GaffMar 27 2009 — edited May 22 2009
Hi:

I've got a procedure (Oracle 10.2.0.3) that was going to perform a query which selected a CLOB and transformed the XML contained in the clob to something else via the application of a stylesheet using DBMS_XMLQuery. But now things have changed and the CLOB won't be a result of a query but passed in as a parameter. What's the easiest way to apply a stylesheet to a CLOB containing XML from within a PL/SQL procedure?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2009
Added on Mar 27 2009
19 comments
2,985 views