Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Newbie question, I think

Newbie question, I think

From: M Ivon M <i.p.kok02_at_kpn.com>
Date: Fri, 04 Feb 2000 08:34:58 GMT
Message-ID: <87e2vh$dqj$1@hdxl22.telecom.ptt.nl> 





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

Received on Fri Feb 04 2000 - 02:34:58 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US