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>
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