Re: Server Message Translation

nimmi60_at_yahoo.com (Nimmi) wrote in message 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.

you'll need to set NLS_LANGUAGE on individual clients. NLS_LANGUAGE <> NLS_LANG, it doesn't include a characterset for instance.

Sybrand Bakker
Senior Oracle DBA Received on Wed Jan 14 2004 - 04:54:43 CST