Re: Server Message Translation

From: Gabriele Lamon <g.lamon.UGO_at_mcg-econ.it>
Date: Wed, 14 Jan 2004 09:52:41 +0100
Message-ID: <bu2vcn$csi$1@grillo.cs.interbusiness.it>

"Nimmi" <nimmi60_at_yahoo.com> ha scritto nel messaggio news:bdefe6fb.0401132047.54f47326_at_posting.google.com...
> Hi,
>
> For ex:
>
> SQL> select * from t;
>
> ORA-00942: table or view does not exist
> should appear as
> ORA-00942: table ou vue inexistante
>

SQL> alter session set nls_language='french';

Session altered.

SQL> select c from t;
select c from t

*
ERROR at line 1:
ORA-00942: Table ou vue inexistante

is it ok?
there are other "nls_" per session parameters that you can alter

SELECT * FROM nls_session_parameters

NLS_LANGUAGE                         ITALIAN
NLS_TERRITORY                       ITALY
NLS_CURRENCY                        L.
NLS_ISO_CURRENCY                 ITALY
NLS_NUMERIC_CHARACTERS     ,.
NLS_CALENDAR                         GREGORIAN
NLS_DATE_FORMAT                  DD-MON-RR
NLS_DATE_LANGUAGE               ITALIAN

Ni hao, Lelle. Received on Wed Jan 14 2004 - 02:52:41 CST