Re: ORA-00600 [19004]

From: Edgar Chupit <chupit_at_gmail.com>
Date: Mon, 29 Nov 2004 08:15:55 +0200
Message-ID: <a8f0771c0411282215713c9382@mail.gmail.com>

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_at_OTIS> var i number;
tt_at_OTIS> alter session set nls_sort=latvian;

Session altered.

tt_at_OTIS> exec dbms_job.submit(:i,'null;', sysdate+1 );

PL/SQL procedure successfully completed.

tt_at_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_at_OTIS> alter session set nls_sort=binary;

Session altered.

tt_at_OTIS> exec dbms_job.change(:i, what=>'null;', next_date=>sysdate+2,interval=>null );

PL/SQL procedure successfully completed.

tt_at_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_at_gmail.com> 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

Received on Mon Nov 29 2004 - 00:11:56 CST