Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle XDK help!

Oracle XDK help!

From: Sanjoy Ghosh <ghoshsanjoy_at_hotmail.com>
Date: 6 Dec 2001 12:51:17 -0800
Message-ID: <bf89818e.0112061251.15dc20b0@posting.google.com>


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>
</xsl:stylesheet>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US