dbms.submit Interval HELP!!!

From: Aaron Lind <linda_at_boystown.org>
Date: 11 Apr 2002 11:16:46 -0700
Message-ID: <a515dee1.0204111016.44abffc5_at_posting.google.com>


I am having a problem setting an interval of the first of every month. The block looks like this:

begin

dbms_job.submit(:jobnumber, 'ndb_job;', to_date(to_char(sysdate, 'yyyymm') || '01', 'yyyymmdd'), last_day(to_date(to_char(sysdate, 'mm/dd/yyyy'), 'mm/dd/yyyy')) + 1);

end;

If I leave the interval as above I get:

ORA-23319: parameter value "01-MAY-02" is not appropriate

If I try and create a varchar2 with the to_char: to_char(last_day(to_date(to_char(sysdate, 'mm/dd/yyyy'), 'mm/dd/yyyy')) + 1, 'mm/dd/yyyy'));

I get the error: ORA-00932: inconsistent datatypes

How can I set the interval so that it runs on the first of every month??

Thanks

AJL Received on Thu Apr 11 2002 - 20:16:46 CEST

Original text of this message