Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle DataType equivalent to SQL double

Re: Oracle DataType equivalent to SQL double

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 8 Sep 2005 08:18:11 +0200
Message-ID: <431fd7a4$0$26162$626a14ce@news.free.fr>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US