Page 1 of 1
ORA-01722: invalid number
Posted: Mon Jun 13, 2005 12:43 am
by akhiln
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
Posted: Mon Jun 13, 2005 1:20 am
by Sreenivasulu
You can try 2 options
1. Check whether data loaded is really numeric
Redirect the data to a file instead of a table
2. Check with debug option in datastage
Regards
Sreeni
Posted: Mon Jun 13, 2005 2:09 am
by akhiln
Thanks Sreeni, One of the numeric field was getting some carriage return charater or space. The problem was with the source sequential file data.
Posted: Mon Jun 13, 2005 3:59 am
by ray.wurlod
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: