Database Administration (MOSC)

MOSC Banner

ORA-01722 Invalid number depending on NLS_LANG

edited Jun 9, 2021 2:31PM in Database Administration (MOSC) 8 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center