Skip to Main Content

Database Software

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!

Help me with XSLT 2.0

587246Aug 31 2007 — edited May 17 2010
I 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...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2010
Added on Aug 31 2007
5 comments
4,503 views