Oracle 11g XMLType.transform has limited XSLT capabilities
 

I'm using Oracle 11g's Java XDK to try and apply XSLT stylesheets to
XMLType objects. If I run the external utility $ORACLE_HOME/bin/
oraxsl on the XML and stylesheet it works fine.

However if I create an XMLTYPE out of the two and try and use the
XMLType.transform method, it seems to have limited capability.
Specifically it doesn't like using the Oracle Java XDK's ability to
use Java methods as XPath functions - this DOES work with oraxsl but
NOT in the database using XMLType.transform.

Is there a way to force XMLType.transform to use an XSLT processor
that recognizes these capabilities?

Thanks in advance for any help.

Re: Oracle 11g XMLType.transform has limited XSLT capabilities
 

Here's a spreadsheet that works with oraxsl but not with the XMLType
transform method. What is causing it to break is attempting to use
the math namespace here. Doesn't transform support the Oracle XSLT
extensions?

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/
Transform"
xmlns:math="http://www.oracle.com/XSL/Transform/java/java.lang.Math">
<xsl:template match="/">
<hello>hello, <xsl:value-of select="math:ceil(25.4)"/></hello>
</xsl:template>
</xsl:stylesheet>

On Apr 28, 2:50*pm, Stryder <stryder...@gmail.com> wrote:
> I'm using Oracle 11g's Java XDK to try and apply XSLT stylesheets to
> XMLType objects. *If I run the external utility $ORACLE_HOME/bin/
> oraxsl on the XML and stylesheet it works fine.
>
> However if I create an XMLTYPE out of the two and try and use the
> XMLType.transform method, it seems to have limited capability.
> Specifically it doesn't like using the Oracle Java XDK's ability to
> use Java methods as XPath functions - this DOES work with oraxsl but
> NOT in the database using XMLType.transform.
>
> Is there a way to force XMLType.transform to use an XSLT processor
> that recognizes these capabilities?
>
> Thanks in advance for any help.

Re: Oracle 11g XMLType.transform has limited XSLT capabilities
 

Stryder wrote:

> Is there a way to force XMLType.transform to use an XSLT processor
> that recognizes these capabilities?

I am not sure anyone reading will know that. You might want to try a
more Oracle specific forum on http://forums.oracle.com/.


--

Martin Honnen
http://msmvps.com/blogs/martin_honnen/

Re: Oracle 11g XMLType.transform has limited XSLT capabilities
 

On Apr 29, 6:51*am, Martin Honnen <mahotr...@yahoo.de> wrote:
> Stryder wrote:
> > Is there a way to force XMLType.transform to use an XSLT processor
> > that recognizes these capabilities?
>
> I am not sure anyone reading will know that. You might want to try a
> more Oracle specific forum onhttp://forums.oracle.com/.
>
> --
>
> * * * * Martin Honnen
> * * * *http://msmvps.com/blogs/martin_honnen/

Thanks, that's good advice.