Re: ORA-00600 [19004]

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
--
http://www.freelists.org/webpage/oracle-l

Other related posts: