如题
begin
sys.dbms_job.submit(job => :job,
what => 'UPDATE_zth('','41','31');',
next_date => to_date('05-04-2012 17:16:08', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'SYSDATE+10/1440');
commit;
end;
/
上边是新建的job里边的what参数不知道该如何写下边是过程UPDATE_zth的参数形式。begin
-- Call the procedure
update_zth(ls_sqlcode => :ls_sqlcode,
ls_zth_y => :ls_zth_y,
ls_zth_m => :ls_zth_m);
end;就后边两个参数需要填下,帮忙看下如何写,谢谢了。
begin
sys.dbms_job.submit(job => :job,
what => 'UPDATE_zth('','41','31');',
next_date => to_date('05-04-2012 17:16:08', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'SYSDATE+10/1440');
commit;
end;
/
上边是新建的job里边的what参数不知道该如何写下边是过程UPDATE_zth的参数形式。begin
-- Call the procedure
update_zth(ls_sqlcode => :ls_sqlcode,
ls_zth_y => :ls_zth_y,
ls_zth_m => :ls_zth_m);
end;就后边两个参数需要填下,帮忙看下如何写,谢谢了。
--改成下面这样试试
sys.dbms_job.submit(job => :job,
what => 'UPDATE_zth('''',''41'',''31'');',
next_date => to_date('05-04-2012 17:16:08', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'SYSDATE+10/1440');
commit;
end;
/
what参数类型为varchar2,sql在执行varchar2类型是对其引号如何操作的?begin
sys.dbms_job.submit(job => :job,
what => 'update_zth('''''''',''''41'''',''''31'''');',
interval => 'SYSDATE+10/1440');
commit;
end;
/