这是我的语句:
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这是怎么回事啊?
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这是怎么回事啊?
把那句改为这个试下
interval => 'to_date(to_char(trunc(sysdate,'hh')+12/24,'yyyymmdd hh24'),'yyyymmdd hh24')'
interval => 'to_date(to_char(trunc(sysdate,''hh'')+12/24,''yyyymmdd hh24''),''yyyymmdd hh24'')'
应该是to_date('2006-07-06 13:00:00', 'yyyy-mm-dd hh24:mi:ss'),