Re: Server Message Translation

"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 Cadot Received on Wed Jan 14 2004 - 02:42:10 CST