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?
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.