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?
Precision too long
Moderators: chulett, rschirm, roy
Precision too long
Every person you meet knows something you don't, Learn from them.
-- H. Jackson Brown
-- H. Jackson Brown
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle