日期:2014-05-16 浏览次数:20939 次
create or replace procedure auto_unseal as cursor c_seal is select sealend,unsealauditing from vary_seal_detail; v_emp c_seal%rowtype; begin for v_emp in c_seal loop if to_char(sysdate,'yyyy-MM-dd')=v_emp.sealend then begin update vary_seal_detail set vary_seal_detail.unsealauditing='1'; end; end if; end loop; end;
begin dbms_job.submit(:job,'auto_unseal',sysdate,'sysdate+1/1440'); commit; end;
variable job number; begin dbms_job.submit(:job,'auto_unseal',sysdate,'sysdate+1/1440'); commit; end;
------解决方案--------------------