RE: dba_jobs nls

From: <Jared.Still_at_radisys.com>
Date: Fri, 30 Jan 2004 09:40:01 -0800
Message-ID: <OFC2CB1571.43B48B88-ON88256E2B.0060D7AB-88256E2B.0060FAAE@radisys.com>

Interesting. I didn't realize that DBA_JOBS stored NLS parms. Learn something every day here.

In that case it appears that the NLS parms are being taken from the client. The two clients you have tested have different NLS parameters, correct?

You might want to incorporate NLS into either the environment via a script before creating the job, or into the job itself.

Jared

John Dunn <john.dunn_at_sefas.co.uk>
Sent by: oracle-l-bounce_at_freelists.org
01/30/2004 07:38 AM
Please respond to oracle-l

        To:     oracle-l_at_freelists.org
        cc: 
        Subject:        RE: dba_jobs nls_env

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
-----------------------------------------------------------------




----------------------------------------------------------------
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 - 11:40:01 CST