| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Oracle XDK help!
Hi All,
Here's my story : I am currenty using Oracle 8i on a UNIX box along
with the Oracle XDK.
Now, I have written a XSL code using the Meunchian method for grouping data. The XSL code goes like this :
<xsl:stylesheet xmlns:util="http://www.oracle.com/XSL/Transform/java/Util"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output indent="yes"/>
<!-- Define Keys to be used for grouping -->
<xsl:key name="PartyKEY" match="ROWSET/ROW" use="PARTY_ID"/>
<xsl:key name="ContractKEY" match="ROWSET/ROW" use="concat(PARTY_ID,'
',CONTRACT_ID)" />
<xsl:template match="/">
<!-- Root Node -->
<DirectPurchaseData>
<!-- Match the first row of a distinct party -->
<xsl:for-each select="/ROWSET/ROW/PARTY_ID[generate-id(.)=generate-id(key('PartyKEY',.)[1]/PARTY_ID)]">
<xsl:sort select="."/>
<TradingPartner ID="{.}">
<Name Type="Common">
<xsl:value-of select="/ROWSET/ROW/PARTY_COMMON_NAME"/>
</Name>
<!-- Create variable for Party Key -->
<xsl:variable name="vParty" select="key('PartyKEY',.)"/>
<!-- Match the first row of a distinct contract -->
<xsl:variable name="vConcatPartyContract"
select="concat(PARTY_ID,'X',CONTRACT_ID)"/>
<xsl:for-each select="$vParty[generate-id()=generate-id(key('ContractKEY',$vConcatPartyContract)[1])]">
<xsl:sort select="."/>
<Contract BusinessMonth="{INVOICE_DATE}" ID="{CONTRACT_ID}"
Type="{CONTRACT_TYPE}">
<Name Type="Recognized">
<xsl:value-of select="CONTRACT_NAME"/>
</Name>
</Contract>
</xsl:for-each>
</TradingPartner>
</xsl:for-each>
</DirectPurchaseData>
</xsl:template>Now when I try to run this using the Oracle XSLT parser, I get the following error : XSL-1036 : Cannot convert string to node-set
Unfortunately, this is a known bug in Oracle XSLT versions 2.0.2.9 or below (which I guess I must be using) (Bug #1403674)
I have trying to look for an upgrade on the Oracle site, but really can't find for anything for 8i. Can somebody please help me ? Is there a workaround to this bug or is there a patch available somewhere ?
Do lemme know, urgently
Thanks
Sanjoy
Received on Thu Dec 06 2001 - 14:51:17 CST
![]() |
![]() |