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!

Columns with number

936749Jun 14 2012 — edited Jun 14 2012

Hi,
I've been asked to investigate an error we recieve in a application:

Link run aborted upon internal error | Fetch failed from table | The database controller returned an error status of DBC_NUMBER_TOO_BIG - Number too large to store.. | Invalid number of decimal places (39,356.629999999997)

I've selected the row from my Oracle 11.2 database and I can see a number stored 39356.63
The colum datatype is "number" without (precision, scale).

1. There is no (precision, scale) configured can we store as many numbers as we want in the column?
2. I'm guessing that the insert to the table is 39,356.629999999997 but we end up with 39356.63 anyone know why?
3. I'm guessing that this is not an Oracle error. Anyone agree or disagree?
Regards
933746

Edited by: 933746 on Jun 14, 2012 11:03 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2012

Added on Jun 14 2012

#11g, #database, #general-database-discussions, #query, #sql, #table

6 comments

474 views