新建Job的时候出现的错误,帮忙看下怎么回事?
这是我的语句:
declare jobnum integer;
begin
sys.dbms_job.submit(job =>jobnum,
what =>'begin
delete t1;
insert into t1(……)
SELECT ……
FROM ……
WHERE ……;
commit;
end;',
next_date => to_date('2006-7月-6 13:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'to_date(to_char(trunc(sysdate,hh)+12/24,''yyyymmdd hh24''),''yyyymmdd hh24'')'
);
commit;
end;
错误信息:
ORA-01861: literal does not match format string
ORA-06512: at line 3
这是怎么回事啊?