Help me with XSLT 2.0
587246Aug 31 2007 — edited May 17 2010I tried to transform from xml to xml using xslt2.0 on oracle 10g r2.
Based on the fact that whenever I added xslt 2.0 features such as "xsl:function","xsl:for-each-group" to stylesheet, oracle 10g gives me an error "LPX-00602: Invalid child element 'for-each-group' of element 'stylesheet'", "LPX-00602:Invalid chid element 'function" of element 'stylesheet".
I strongly suspect my oracle 10g r2 doesn't support xslt 2.0 features.
But the whitepapar says oracle 10g r2 supports xslt 2.0, I'm confused.
Now I'm searching for the posibility I didn't install full XMLDB package when I installed Oracle 10g R2 and if this is that case, what should I chek with my oracle?
Is there anyone who sucessfully used XSLT 2.0 features to transform xml-to-xml using SQL like this.
select XMLTransform(XDBURIType('/AI059.xml').getXML(),XDBURIType('/AI059.xsl').getXML()).getClobVal() from dual;
the part of stylesheet is below.
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:fn="http://www.w3.org/2005/xpath-functions" xmlns:xbrli="http://www.xbrl.org/2003/instance" xmlns:link="http://www.xbrl.org/2003/linkbase" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:fines-f-ai="http://fss.xbrl.or.kr/kr/br/f/ai/2007-06-30" xmlns:fines-b-ai="http://fss.xbrl.or.kr/kr/br/b/ai/2007-06-30" xmlns:xbrldt="http://xbrl.org/2005/xbrldt" xmlns:ref="http://www.xbrl.org/2004/ref" xmlns:xbrldi="http://xbrl.org/2006/xbrldi" xmlns:iso4217="http://www.xbrl.org/2003/iso4217" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<!-- PART I -->
<xsl:variable name="FINANCE_CD" select="/REPORT/@FCD"/>
<xsl:variable name="BASE_MONTH" select="/REPORT/@BMN"/>
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:for-each-group select="RECORD">
...
</xsl:for-each-group>
<xsl:function name="fines-b-aa:mapping">
...
</xsl:function>
Help me out !! I've been spent almost two days with this...