Changing the language of Oracle error messages in SQL Developer

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:

Error report:
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:

Error report:
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

 

Matthias

Advertisements

3 Responses to Changing the language of Oracle error messages in SQL Developer

  1. Pingback: Fix Oracle Sql Developer Error 1555 Windows XP, Vista, 7, 8 [Solved]

  2. Pingback: Fix Sql Developer Error Log Windows XP, Vista, 7, 8 [Solved]

  3. Pingback: Fix Apex Data Loader Error Email Notifications Windows XP, Vista, 7, 8 [Solved]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: