Re: Newbie question, I think

Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>A copy of this was sent to i.p.kok02_at_kpn.com (M Ivon M)
>(if that email address didn't require changing)
>On Fri, 04 Feb 2000 08:34:58 GMT, you wrote:

>>Hi all.
>>
>>I'm trying to submit a job by executing the following command:
>>DBMS_JOB.SUBMIT(NEWJOBNUM,
>> 'NAMEOFPROCEDURE;',
>> SYSDATE + 5/(24*60),
>> 'NEXT_DAY(TRUNC(SYSDATE), ''MONDAY'') + 22/24');
>>
>>The error message I get says 'not a valid day of the week'.
>>I tried MONDAY, Monday, monday and MON.
>>
>>What is wrong?
>>
>>M Ivon M

>What nls_language are you using? Consider:
<...>
>When the language is 'french' for example, i must use Lundi which is Monday....

D'oh! That was exactly it. (Dutch instead of French.)

I assumed English would be the way to go. In fact, I copied the lines from an existing procedure in the same database...

Thanks,
M Ivon M Received on Fri Feb 04 2000 - 08:14:59 CST