Contact the local database administrator to setup the NLS Parameters.
Here why this query works on SQL Navigator 6.7 vs 7.1
select to_number('10,5')
Is possible syntax is part of the ( NLS_LANG ).
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,';
select to_number('10.5') from dual;
swap it around and you get the error
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.';
select to_number('10.5') from dual;
In United State we use ( ,.) and Centro and South America is (.,)
Run this query and check the results;
select parameter, value
from nls_session_parameters
where parameter = 'NLS_NUMERIC_CHARACTERS'
It is possible that version 6.7 is configured with (.,) Period and Comma and version 7.1 is configured with (,.) Comma y Period
This are based on KB; https://support.quest.com/sql-navigator-for-oracle/kb/213249
