Start a new topic

ORA-01722: Invalid number

Hi all, my colleague and I are running the same query however I get the following error:

 ORA-01722: Invalid number

We are both using DBVisualizer 9.2.14 but we have different configurations, i am using Windows 7. I suspect it has something today with the language settings. In Europe we are using a comma (,) in decimal numbers. 

The used command is:

CAST( (query)as number(20,1))

Does anybody have any idea how to solve this?

1 Comment

Can you please enable debug in DbVisualizer in Tools->Debug Window and in the Debug tab (check Debug DbVisualizer only). Then re-run the query and open Help->Contact Support to send the log file to us.



Login or Signup to post a comment