Page 1 of 1

Precision too long

Posted: Sun Sep 24, 2006 12:00 pm
by iwin
Hi,
I am getting an error "value larger than specified precision allowed for this column" while loading the table, I dont know the exact column for this error . but i have a column in table whose data type is number 9(5) and for this field i am getting value from source as 12345.98000.
Can anyone suggest me if this value is reason for this error?

Posted: Sun Sep 24, 2006 3:17 pm
by kcbland
It looks to be the problem. Total size of 9 with decimal of 5 leaves 4 for the leading values in front of the decimal.