Server Message Translation

[siraj777]

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.

 

[sem]

As for NLS_LANG, you're on the right track: its structure is <language>_<territory>.<charset>. You need <language> part, it's responsible for translating Oracle messages.

You may also issue from somewhere during startup (after connecting, of course):

alter session set nls_language=french



Regards, Dima

http://seminihin.narod.ru

 

[avjoshi]

Thats strenge!

SQL> alter session set nls_language=french;

Session altered.

SQL> select 1 from anand;
select 1 from anand
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>

Anand