Re: Oracle DataType equivalent to SQL double

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Thu, 08 Sep 2005 02:08:51 GMT
Message-ID: <Xns96CAC2C808087SunnySD@68.6.19.6>

sunny076_at_yahoo.com wrote in
news:1126110593.288225.136410_at_g44g2000cwa.googlegroups.com:

> Hi,
>
> I am new to Oracle and trying to migrate a SQL database to Oracle
> database. However, I stumble over SQL Double datatype which is of range
> -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and
> 2.2250738585072014E-308 to 1.7976931348623157E+308. I look everywhere,
> but could not find the corresponding one that works yet. I tried
> FLOAT(49) and NUMBER, but when I am inserting I got ORA-01426: numeric
> overflow.
>
> I would appreciate if anyone can enlighten me.
>
> Sunny
>

01426, 00000, "numeric overflow"
// *Cause: Evaluation of an value expression causes an overflow/underflow. // *Action: Reduce the operands.

Since you've chose to avoid showing anyone your code AND data, we can only guess at the problem & possible solution.

Maybe it is an application problem & not really an Oracle problem. Received on Wed Sep 07 2005 - 21:08:51 CDT