ORA-01722: invalid number

akhiln · Post by **akhiln** » Mon Jun 13, 2005 12:43 am

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

Sreenivasulu · Post by **Sreenivasulu** » Mon Jun 13, 2005 1:20 am

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

akhiln · Post by **akhiln** » Mon Jun 13, 2005 2:09 am

Thanks Sreeni, One of the numeric field was getting some carriage return charater or space. The problem was with the source sequential file data.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 13, 2005 3:59 am

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:

Code: Select all

oerr ORA -1722