Loss of Decimal Values

Mahmoud_Dayeh_(ecead_mad_-_(deleted))

We are having a SQL statement like below:select SUM(AMOUNT) from SALARY which returns values in decimal format.When we get the value in a Recarray, it doesn't give us the decimal values.For e.g. If we have values of 120 & 130.40 in the DB, the query should return back a value of 250.40, whereas we get only 250 and 0.40 is ignored.Why is this happening??? Can't we use the MATH functions of Oracle in LL Builder. The Livelink version is LL 9.1 (SP3) with same version for Builder as well. Oracle version is 8.1.7.The query executes perfectly fine in SQLPLUS with correct results.Thanks in advance.