Re: Server Message Translation

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 14 Jan 2004 09:31:04 GMT
Message-ID: <bu328n$cklbi$1@ID-82536.news.uni-berlin.de>

>
> "Nimmi" <nimmi60_at_yahoo.com> a écrit dans le message de
> news:bdefe6fb.0401132047.54f47326_at_posting.google.com...

>> Hi,
>>
>> I am using Oracle 9i as database and the frontend application in
>> PowerBuilder 8 which will be installed in English or French Version
>> per user basis. I was successful in translating the frontend text and
>> error messages. Please let me know how to translate the server
>> messages from English to French for a PARTICULAR SESSION ( per user)
>> in ORACLE. I have a multi lingual database.
>>
>> For ex:
>>
>> SQL> select * from t;
>>
>> ORA-00942: table or view does not exist
>> should appear as
>> ORA-00942: table ou vue inexistante
>>
>> I used NLS_LANG parameter for date, currency etc., but for changing
>> the messages the parameter needs to be set in init.ora which is common
>> for all sessions in the instance and I don't need that.
>>
>> Your help is appreciated.

>
> Server messages language depends on NLS_LANGUAGE which is part of NLS_LANG.
> If you set it in your client there is no difference with date language (depends on
> NLS_DATE_LANGUAGE,
> derived from NLS_LANGUAGE and NLS_LANG) or currency (derived from NLS_TERRITORY).
> Either you can change it with an alter session.
>
> SQL> select * from t;
> select * from t
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> SQL> alter session set nls_language='French';
>
> Session modifiée.
>
> SQL> select * from t;
> select * from t
> *
> ERREUR à la ligne 1 :
> ORA-00942: Table ou vue inexistante
>
> Regards

Michel,

This was about the same post that I wanted to make. But when I double checked with my SQL*PLUS, it didn't work:

... Copy paste:

SQL> select * from t;
select * from t

              *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> alter session set nls_language=French;

Session altered.

SQL> select * from t;
select * from t

              *
ERROR at line 1:
ORA-00942: table or view does not exist

... end copy paste

The version is 9i on Linux.

I am pretty sure that I had this working once, but don't know what version that was at the time.

If anyone can explain this behavior...?

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch

Received on Wed Jan 14 2004 - 03:31:04 CST