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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle XDK help!

Re: Oracle XDK help!

From: Harri Kaukovuo <harri.kaukovuo4_at_nic.fi>
Date: 7 Dec 2001 06:04:56 GMT
Message-ID: <9upm68$qv0$1@news1.song.fi>


You can use the latest production release XDK 9.0.1 with 8i. Either externally or internally (loading the java classes into database).

ghoshsanjoy_at_hotmail.com (Sanjoy Ghosh) wrote in news:bf89818e.0112061251.15dc20b0_at_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('PartyKE
> Y',.)[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',$vConcatPart
> yContract)[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
>

-- 
-----------------------------------------------------------------------
Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4
Received on Fri Dec 07 2001 - 00:04:56 CST

Original text of this message

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