Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01426: numeric overflow, while migrating "float" values

777619Jun 16 2010 — edited Jul 2 2010

When I try to insert a value of *2.58612749363472E302* (originally a "float" in SQL DB) into an Oracle column of type float(126), I get this error "ORA-01426: numeric overflow"

I tried changing the column type to BINARY_FLOAT, BINARY_DOUBLE, but I still get same error.

I'm using Oracle SQL Developer (2.1.1.64.45) to migrate a SQL Server 2005 Database to Oracle 11g.

Do you have any thoughts on this? Or workarounds?

Thanks in advance.
Arul

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2010

Added on Jun 16 2010

#11g, #database-and-application-migrations, #sql

4 comments

2,689 views