Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle DataType equivalent to SQL double
<sunny076_at_yahoo.com> a écrit dans le message de news: 1126143806.603485.227240_at_z14g2000cwz.googlegroups.com...
| Thanks a lot for your reply. I did try with FLOAT(126) as the manual
| said, but I still get the numeric overflow error when I was inserting
| data of double data type. My Oracle version is 9i.
|
| I would greatly appreciate your help to solve this problem.
|
| Sunny
|
As i previously said the limit is 1E+126 so you can't insert 1E+308. There is no solution unless you change your values. Btw, what can have a value of 1E+308?
Regards
Michel
Received on Thu Sep 08 2005 - 01:18:11 CDT