Changing the language of Oracle error messages in SQL Developer
April 26, 2012 3 Comments
Environment: SQL Developer 3.1.07, Windows 7
The regional format of my Windows 7 PC is set to “Dutch (Belgium)”. This means that some programs will display error or other messages in Dutch, which can be a problem when you need to look up information on the internet.
For example, I had the following Dutch error message in SQL Developer:
ORA-06502: PL/SQL: numerieke fout of fout in waarde .
ORA-06512: in “SYS.OWA_UTIL”, regel 356
ORA-06512: in “APEX_040100.HTMLDB_UTIL”, regel 449
ORA-06512: in regel 2
To change this into another language, you need to modify the NLS “Language” setting in SQL Developer. You can do this from the “Tools” menu, then “Preferences”, “Database” and “NLS”. Change the language in the first drop down list (“Language”). Once you click “OK”, the changes take immediate effect. You don’t need to restart SQL Developer.
After the language change, this is how my error message now looks like:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at “SYS.OWA_UTIL”, line 356
ORA-06512: at “APEX_040100.HTMLDB_UTIL”, line 449
ORA-06512: at line 2