Cannot convert number to NodeSet

anarleti · May 3rd, 2010, 08:10 AM

Hi,

iam using below syntax in my xsl :

<xsl:variable name="x"><xsl:value-of select="sum(for $t in current-group()/C_FUNCTIONAL_TOTAL return number(translate($t, ',.', '.')))"/></xsl:variable>

and it is giving below error:

Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert number to NodeSet.

any suggestions?

Thanks
Anil

Martin Honnen · May 3rd, 2010, 08:25 AM

I would certainly use

Code:

<xsl:variable name="x" select="sum(for $t in current-group()/C_FUNCTIONAL_TOTAL return number(translate($t, ',.', '.')))"/>

instead of your code but I doubt it will make a difference.
Isn't there any Oracle forum where you could ask about peculiarities of the Oracle XSLT processor?

anarleti · May 3rd, 2010, 08:30 AM

Hi,

i have posted it on http://forums.oracle.com
but unfortunately iam not geting any answers :( . kindly let me know if there are any other forums.

i will try to do with your given syntax and update you

Thanks
Anil

mhkay · May 3rd, 2010, 12:47 PM

It's my understanding that Oracle implement a few selected features from XSLT 2.0 but they don't implement the full spec. Your code looks as if it work fine with a product that implements all of XSLT 2.0.

anarleti · May 4th, 2010, 08:25 AM

Hi,

i have a small question...

iam using this syntax ..
<xsl:variable name="x"><xsl:value-of select="sum(for $t in current-group()/C_FUNCTIONAL_TOTAL return number(translate($t, ',.', '.')))"/></xsl:variable>

i guess it is giving error "Cannot convert number to NodeSet" because,
it is failing to convert the whole numbers which don't have any decimal or group seperator ( ex : 10 , 20 , 30 )
as iam using translate function may be it is expecting something like 10.00,20 to translate but getting only 10

the function translate($t, ',.', '.') is translating into US for both whole numbers and for decimal numbers in Jdeveloper
but this is not happening in Oracle Apps.

is there any way to find out the number format in C_FUNCTIONAL_TOTAL and change it US formate and then adding them ,which can works for both whole numbers and decimal seperaters.
any work around??

Thanks
anil

mhkay · May 4th, 2010, 08:52 AM

I am sorry, I do not know why this is failing. It looks valid in XSLT 2.0 but invalid in 1.0. I don't know why it is trying to convert a number to a node-set, or why it is failing. If you can't get help from the people who support the product, I suggest you try a different product.