prateek_nanda
New User
Joined: 13 Jul 2007
Posts: 13
Location: Gurgaon
|
|
|
|
Hi ,
I am getting 802 for one of my Queries below is the error msg
SQLCODE = 802, WARNING: EXCEPTION ERROR OUT OF RANGE HAS OCCURRED
DURING LN OPERATION ON FLOAT DATA, POSITION ...
I am trying to multiply column values using LOG logic
EXP((SUM(CAST(LN(ABS(TOT_RET_CALC))AS DOUBLE))))
Tried to cast it in Double float erc. nothing worked.
if anyone could suggest me something on this??
Thanks!! |
|
