oracle创建jobs定时任务报错:PLS-00306: wrong number or types of arguments in call to 'JOB',
分享于 点击 46277 次 点评:201
oracle创建jobs定时任务报错:PLS-00306: wrong number or types of arguments in call to 'JOB',
原脚本:
begin
sys.dbms_job.submit(job => job,
what => 'xxx;',
next_date => to_date('10-12-2019', 'dd-mm-yyyy'),
interval => 'TRUNC(SYSDATE + 1)');
commit;
end;
报错:
修改后:
declare
job number;
begin
sys.dbms_job.submit(job => job,
what => 'xxx;',
next_date => to_date('10-12-2019', 'dd-mm-yyyy'),
interval => 'TRUNC(SYSDATE + 1)');
commit;
end;
相关文章
- 暂无相关文章
用户点评