Oracle Error Message Language
Oracle11gR2 ORA-06502 ORA-24247 calling UTL_MAIL from Oracle11gR2 → Changing the language of Oracle error messages in SQLDeveloper 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: 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 Rate this:Share this:Click to share on Twitter (Opens in new window)Share on Facebook (Opens in new window)Click to share on Google+ (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to email (Opens in new window)Click to print (Opens in new window)Like this:Like Loading... Related Filed under SQL Developer, Windows 7 Tagged with error message, language, language change, nls, sql developer, windows 7 3 Responses to Changing the language of Oracle error messages in SQLDeveloper Pingback: Fix Oracle Sql Developer Error 1555 Windows XP, Vista, 7, 8 [Solved] Pingback: Fix Sql Developer Error Log Windows XP, Vista, 7, 8 [Solved] Pingback: Fix Apex Data Loader Error Email Notifications Windows XP, Vista, 7, 8 [Solved] Leave
Post your question and get tips & solutions from a community of 418,615 IT Pros & Developers. It's quick & easy. NLS_LANG and language of ORA-[xxxxx] P: n/a Michael John Hey, how can I get ORA-..... error messages in languages other than english. I did a alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1'; but this only threw an ORA-00922. Or I'm wrong and NLS_LANGUAGE and NLS_TERRITORY doesn't have an effect on the text of ORA- error messages at all? Any hints? TIA, mic Jul 19 '05 #1 Post Reply Share this Question 3 Replies P: n/a https://matthiashoys.wordpress.com/2012/04/26/changing-the-language-of-oracle-error-messages-in-sql-developer/ Romeo Olympia Even just "ALTER SESSION SET NLS_LANGUAGE = GERMAN;" should accomplish this. But check if you have the necessary mesg files first. (I think you need ORAD.MSB at least). am********@gmx.at (Michael John) wrote in message news:<8d*************************@posting.google.c om>... Hey, how can I get ORA-..... error messages in languages other than english. I did a alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1'; but this only threw an ORA-00922. Or I'm https://bytes.com/topic/oracle/answers/65676-nls_lang-language-ora-xxxxx wrong and NLS_LANGUAGE and NLS_TERRITORY doesn't have an effect on the text of ORA- error messages at all? Any hints? TIA, mic Jul 19 '05 #2 P: n/a sybrandb am********@gmx.at (Michael John) wrote in message news:<8d*************************@posting.google.c om>... Hey, how can I get ORA-..... error messages in languages other than english. I did a alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1'; but this only threw an ORA-00922. Or I'm wrong and NLS_LANGUAGE and NLS_TERRITORY doesn't have an effect on the text of ORA- error messages at all? Any hints? TIA, mic NLS_LANG and NLS_LANGUAGE are 2 different things (as documented). NLS_LANG can be set as environment variable (Unix) or registry variable (Winblows) only, it can't be set using ALTER SESSION. NLS_LANGUAGE can be set using ALTER SESSION and will impact the error messages. Prerequisites are - you actually did install the message libraries, choosing at least 2 languages during installation - ORA_NLS33 has been set Other than that: no joy Please also read up on NLS in the NLS doco. Sybrand Bakker Senior Oracle DBA Jul 19 '05 #3 P: n/a Michael John Hello Romeo hello Sybrand, thanks very much for your assistance. I will have to contact my local
of 1 oracle error message localization by slaxman » Mon 14 Nov 2011 22:13 The DB is in german language but the oracle error http://forums.devart.com/viewtopic.php?t=22571 message that comes via devart is in english. I am expecting the message to be in German and I am wondering whether devart is translating it. I don't see any language prefs. during devart install. So, Is english the default and only language supported? If not, how to change it? Is there a resource assembly (.NET like) oracle error for each language? thanks slaxman slaxman Posts: 47Joined: Wed 16 Sep 2009 20:09Location: United States Top by Shalex » Tue 15 Nov 2011 15:43 slaxman wrote:The DB is in german language but the oracle error message that comes via devart is in english. Please tell us your current language for non-Unicode programs from the Control Panel oracle error message > Region and Language menu of your operating system. If you are using the OCI connection mode (via Oracle client), the language of the messages is defined by the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\%HomeName% > NLS_LANG setting of your Oracle client: http://www.orafaq.com/wiki/NLS_LANG. Anyway, you can change language for a particular connection by executing ALTER SESSION SET NLS_LANGUAGE = 'YOUR_LANGUAGE' on the connection. Shalex Devart Team Posts: 7021Joined: Thu 14 Aug 2008 12:44 Top by Shalex » Wed 16 Nov 2011 11:10 UPDATE: There are two types of the errors: 1) errors which are generated at the server side (e.g., "ORA-00001: unique constraint violated"). Language of these errors is defined by the NLS_LANGUAGE server variable and doesn't depend on the client settings. 2) errors which are generated at the client side (e.g., "NET: Invalid SID"). The language depends on HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\%HomeName% > NLS_LANG setting of your Oracle client in the OCI mode. And the language is always English in the Direct mode. Shalex Devart Team Posts: 7021Joined: Thu 14 Aug 2008 12:44