Page 1 of 1
oracle error message localization
Posted: Mon 14 Nov 2011 22:13
by slaxman
The DB is in german language but the oracle error 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) for each language?
thanks
slaxman
Posted: Tue 15 Nov 2011 15:43
by Shalex
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 > 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.
Posted: Wed 16 Nov 2011 11:10
by Shalex
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.