ORA-23319: parameter value "14-OCT-05" is not appropriate

From: jwa6 <jwagans_at_yahoo.com>
Date: 14 Sep 2005 14:04:25 -0700
Message-ID: <1126731865.564193.280530@g43g2000cwa.googlegroups.com>

this is the error....

SP_SUBMIT_VALIDATIONS_PURGE is BEING SUBMITTED. Error running SP_SUBMIT_VALIDATIONS_PURGE -23319 ORA-23319: parameter value "14-OCT-05" is not appropriate

this is the code:

v_run_date DATE := LAST_DAY(TRUNC(sysdate)+(03+030/60)/24) + 15;

DBMS_JOB.SUBMIT(v_JobNum, -- Return of job number

   'SP_SUBMIT_VALIDATIONS_PURGE;', -- Procedure to submit

    v_run_date,               -- Next date/time to run
    add_months(sysdate,1));           -- Interval

Im trying to run this at the 15th of each month at 330 AM. The error is coming from "Interval parm"

the date in the error is what I want..15 oct 2005.  I dont understand the error however.

this little block works fine:

 declare

       v_date date;
     --

   begin
    v_date := LAST_DAY(TRUNC(sysdate)+(03+030/60)/24) + 15 dbms_output.put_line('v_date = '||to_char(v_date,'DD-MON-YYYY HH24:MI:SS'));

   end;
   /

v_date = 15-OCT-2005 03:30:00

jwa Received on Wed Sep 14 2005 - 16:04:25 CDT