RE: dba_jobs nls

From: John Dunn <john.dunn_at_sefas.co.uk>
Date: Fri, 30 Jan 2004 15:38:42 -0000
Message-ID: <A05E0089719FD311911400A0249EE7E5B95690@guest-wv-50.ripe.net>

select nls_env from dba_jobs

When started from a script on Solaris

NLS_ENV

NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENC

Y='AMERICA' NLS_NUMERIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MM-YYYY:HH24:MI:SS'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'

When started from a VB client session on Windows 2000 :

NLS_LANGUAGE='ENGLISH' NLS_TERRITORY='UNITED KINGDOM' NLS_CURRENCY='#' NLS_ISO_C
URRENCY='UNITED KINGDOM' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='ENGLISH' NLS_SORT='BINARY' NLS_DATE_FORMAT is defined as DD-MM-YYYY:HH24:MI:SS in the initSID.ora file

John

-----Original Message-----
From: Jared Still [mailto:jkstill_at_cybcon.com] Sent: 30 January 2004 15:11
To: Oracle-L Freelists
Subject: Re: dba_jobs nls_env

That's interesting, in the absence of 'alter session' I would expect them to come from the default settings in nls_session|instance|database_parameters.

What is the evidence that indicates that there is a difference dependent on client?

Jared

On Fri, 2004-01-30 at 06:55, John Dunn wrote:
> How does dba_jobs decide what it's nls_env values are?.
>
> They seem to vary according to whether I queue the job from a windows
client
> or from unix.
>
> John
>
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jan 30 2004 - 09:38:42 CST

RE: dba_jobs nls_env