Oracle has built in ways to do this. You can use SQLX, in which you change your query to return the xml structure you want, or you can also use Oracle's XDK.
SQLX example:
SELECT XMLELEMENT("PARTS",
XMLAGG(
XMLELEMENT("PART",
XMLFOREST(NVL(unit_price...
Hi tsuji,
Thanks so much for the help! The template is almost working perfectly. I had to remove the @ from <xsl:apply-templates select="@*|node()"/>, but otherwise it was right on the money! The last thing that seems to be happening is that it's escaping my apostrophes and quotation marks. So...
Hi tsuji,
I had to create a new handle because my old account is throwing an error when I log in. Anyway, thanks for the response! My XSLs are not physical files, but really just a CLOB in the database. I tried to hit my webservice to deliver the xsl by saying <xsl:import...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.