I am getting an error like ORA-01722: invalid number. I am writing to an ORACLE table. My source is a sequential file.
I checked all the columns and verified that numeric columns are getting only numeric values.
Any suggestions
ORA-01722: invalid number
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Congratulations on solving it. :D
Error codes like ORA-01722 are generated by Oracle. You can obtain more information about them using the oerr command on the DataStage server machine. For example:
Error codes like ORA-01722 are generated by Oracle. You can obtain more information about them using the oerr command on the DataStage server machine. For example:
Code: Select all
oerr ORA -1722
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.