ORA-01722 Invalid number depending on NLS_LANG
Hello,
I recently installed oracle client 19c (x32 & x64) on a new PC and now I get the error ORA-01722 executing the simple statement "SELECT TO_NUMBER('1.53') FROM DUAL". I'm testing and found that the value for NLS_LANG defined in the windows registry by oracle client installation is "SPANISH_SPAIN.WE8MSWIN1252". If I define the value as "AMERICAN_AMERICA.WE8MSWIN1252" the select runs properly and return the number 1.53. The database is 12c and the NLS_CHARACTERSET is WE8ISO8859P15. I tested chaning the NLS_LANG parameter to SPAIN_SPANISH.WE8ISO8859P15, but the error still occurs, although if I define AMERICAN_AMERICA.WE8ISO8859P15, it runs properly too. The regional settings are identical