这近在学习创建job调用有参过程,我在本机所有的都建好了也可以运行,可没过多久不知道是什么原因job自动就broken了我手动将broken点掉再手动运行报错,错误如下:
ora-12011:无法执行1作业
ora-06512:在"sys.dbms_ijob",line 651
ora-06512:在"sys.dbms_job",line 284
ora-06512:在line 1job脚本:begin
sys.dbms_job.submit(job => :job,
what => 'test(to_date(to_char(sysdate,''yyyymmdd''),''yyyymmdd''));',
next_date => to_date('01-01-4000', 'dd-mm-yyyy'),
interval => 'TRUNC(sysdate,''mi'')+2/(24*60)');
commit;
end;
/过程脚本:create or replace procedure test(iv_date in varchar2) is
begin
insert into a values(to_char(to_date(iv_date,'yyyymmdd')));
end;请各位oracle高手指点下一二小弟万分感激!
ora-12011:无法执行1作业
ora-06512:在"sys.dbms_ijob",line 651
ora-06512:在"sys.dbms_job",line 284
ora-06512:在line 1job脚本:begin
sys.dbms_job.submit(job => :job,
what => 'test(to_date(to_char(sysdate,''yyyymmdd''),''yyyymmdd''));',
next_date => to_date('01-01-4000', 'dd-mm-yyyy'),
interval => 'TRUNC(sysdate,''mi'')+2/(24*60)');
commit;
end;
/过程脚本:create or replace procedure test(iv_date in varchar2) is
begin
insert into a values(to_char(to_date(iv_date,'yyyymmdd')));
end;请各位oracle高手指点下一二小弟万分感激!
test过程的参数是varchar2类型,你为何给其传递date参数呢?
begin
sys.dbms_job.submit(job => :job,
what => 'test(to_char(sysdate,''yyyymmdd''));',
next_date => to_date('01-01-4000', 'dd-mm-yyyy'),
interval => 'TRUNC(sysdate,''mi'')+2/(24*60)');
commit;
end;