Hi,
When iam trying to load the data to oracle table it throws the error
xyz..Transformer_1: ORA-01438: value larger than specified precision allows for this column.
But i have checked the datatype and length of that field and it is Decimal and Precision 9.
When i tried to insert the '1' also it throws the same error.
any help would be appreciated.
Oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Oracle
Import the table definition from Oracle, perhaps into a different category. How is the column defined there? You need to match that in your job. It is possible that "someone" has changed it in the database since you last imported it.pandu80 wrote:Hi,
When iam trying to load the data to oracle table it throws the error
xyz..Transformer_1: ORA-01438: value larger than specified precision allows for this column.
But i have checked the datatype and length of that field and it is Decimal and Precision 9.
When i tried to insert the '1' also it throws the same error.
any help would be appreciated.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom