Re: ORA-00600 [19004]
- From: Edgar Chupit <chupit@xxxxxxxxx>
- To: mhthomas <qnxodba@xxxxxxxxx>
- Date: Mon, 29 Nov 2004 08:15:55 +0200
Yep, you are right, I shuldn't make conclusions that fast.
Correct statement is that jobs submitted via dbms_job inherits
sessions NLS parameters.
Thank you for correction.
tt@OTIS> var i number;
tt@OTIS> alter session set nls_sort=latvian;
Session altered.
tt@OTIS> exec dbms_job.submit(:i,'null;', sysdate+1 );
PL/SQL procedure successfully completed.
tt@OTIS> select nls_env from user_jobs where job = :i;
NLS_ENV
--------------------------------------------------------------------------------
NLS_LANGUAGE='ENGLISH' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY
='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANG
UAGE='ENGLISH' NLS_SORT='LATVIAN'
tt@OTIS> alter session set nls_sort=binary;
Session altered.
tt@OTIS> exec dbms_job.change(:i, what=>'null;',
next_date=>sysdate+2,interval=>null );
PL/SQL procedure successfully completed.
tt@OTIS> select nls_env from user_jobs where job = :i;
NLS_ENV
--------------------------------------------------------------------------------
NLS_LANGUAGE='ENGLISH' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY
='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANG
UAGE='ENGLISH' NLS_SORT='BINARY'
On Fri, 26 Nov 2004 15:06:49 -0500, mhthomas <qnxodba@xxxxxxxxx> wrote:
> Hi,
>
> In your second case, you don't show changing the NLS to binary. What
> are you trying to inherit?
>
> I think your second case works as expected. You set the sort once in
> your session and it applies to both job calls?
>
> Am I missing your point?
--
Edgar
--
//www.freelists.org/webpage/oracle-l
Other related posts:
