Re: Server Message Translation

"Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> a écrit dans le message de news:bu328n$cklbi$1_at_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

Are you sure you installed the french messages? When you installed Oracle, on one of screens you have a button "Product Languages" to choose the language you want to install.
If french messages are not installed then default language is used that is English.

Regards
Michel Cadot Received on Wed Jan 14 2004 - 04:51:33 CST