ORA-01008:并非所有变量都以绑定、、、求解！！！

[devil_bin]

存储过程:

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;

job定时器:

begin
     dbms_job.submit(:job,'auto_unseal',sysdate,'sysdate+1/1440');
     commit;
end;

求各位大侠帮忙看看错在何方、、在网上找了很多就是解决不了。

[programmerxiaocai]

declare job number;
begin
sys.dbms_job.submit(job => job,
what => 'begin auto_unseal(); end;',
next_date => to_date('14-04-2011 00:10:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate+1)+10/1440');
commit;
end; 自己改一下时间

[cosio]

variable job number;
begin
     dbms_job.submit(:job,'auto_unseal',sysdate,'sysdate+1/1440');
     commit;
end;

[devil_bin]

[Quote=引用楼主 devil_bin 的回复:]
存储过程:

SQL code


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
……
[/Quote]
太感谢1楼的大哥了、、完全正确、、、、、

[a120255857]

[devil_bin]

[Quote=引用 1 楼 programmerxiaocai 的回复:]
declare job number;
begin
sys.dbms_job.submit(job => job,
what => 'begin auto_unseal(); end;',
next_date => to_date('14-04-2011 00:10:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysd……
[/Quote]
哎呀、、、失误失误、、上面我引用错误、、、引用到我自己的了。。。这个引用才是对的、、啊哈哈哈哈
再次感谢这位大侠！！！

[edit_1]

大虾牛。