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

Andy Hassall wrote:
> 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

thanks.....The making of the interval parm a string did it. I wasnt picking that up in the oracle. Thanks for your input....I was stumped!!!

jim agans Received on Thu Sep 15 2005 - 08:14:07 CDT