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></xsl:template>
</DirectPurchaseData>
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