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

On 14 Sep 2005 14:04:25 -0700, "jwa6" <jwagans_at_yahoo.com> wrote:

>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

http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_job.htm#i1000807  

 The interval parameter is a string, not a date; you pass it an expression that is then re-evaluated each time the job is run, to work out the next run date.

 You're passing it a date, which gets converted to a string representation of a date, and then it tries to evaluate '14-OCT-05' as an expression.

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 expression

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool