ORA-01722: invalid number

[dtcheung]

When trying to import tables i get the ORA-01722: invalid number error where the number has a decimal. Open with a text editor and it shows the decimals as commas. Is there a way to fix this?

 

[Marco Kalter]

How did you export this data?

 

[Dave Montgomery]

Was there ever a solution to this? I am seeing the same problem. FYI: NLS_NUMERIC_CHARACTERS=., on both the export server and import server

 

[Marco Kalter]

Can you send me the export file, or -if it is too big- create a smaller export file to reproduce the issue?

 

[Dave Montgomery]

No problem. I can't see an "attach file" option. Shall I e-mail it instead?

 

[Marco Kalter]

If it's not too big, you can send it to support@allroundautomations.com.

 

[Dave Montgomery]

They are actually quite reasonable. I have sent it to support@allroundautomations.com. Thanks.

 

[Marco Kalter]

I have received it, and will check it out shortly.

 

[Dave Montgomery]

Any updates on this issue? We are still seeing this behaviour.

 

[Marco Kalter]

Not yet, but we still need to look at some NLS related things.