Oracle Weblogic Server (MOSC)

MOSC Banner

XQuery fn-bea:execute-sql large value result

edited Apr 3, 2013 5:32AM in Oracle Weblogic Server (MOSC) 1 comment
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.


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center