Restituisci
-
Titolo
Get "ORA-01722 Invalid number" running SELECT TO_NUMBER('10.5') FROM DUAL query -
Descrizione
SQL Navigator showed the error : "ORA-01722 Invalid number", when trying to run the following query:
SELECT TO_NUMBER('10.5') FROM DUAL;
-
Causa
Values in the NLS parameters are not consistent or properly configured. -
Risoluzione
Contact the local database administrator to setup the NLS Parameters.
Here why this query works on SQL Navigator 6.7 vs 7.1select 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 errorALTER 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, valuefrom nls_session_parameterswhere 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 PeriodThis are based on KB; https://support.quest.com/sql-navigator-for-oracle/kb/213249
