XQuery fn-bea:execute-sql large value result
Hi,
we have an xquery which calls for an sql sequence's next value as follows:
fn-bea:execute-sql('jdbc/datasourceNonXA', xs:QName('result'),'select ABC_CORRELATION_SEQUENCE.nextval from dual')
The returned results are, at the moment, returning very large values which in the xquery get seen as in the following returned example value:
1.0356772E7
Not knowing much about weblogic, xquery and sql, I am looking to see what is the best way to see the returned values as whole numbers. e.g. 10356772 instead of 1.0356772E7.
Thanks in advance for any advise on this matter.
0