建存储过程:create or replace procedure syndataeverynight
(IDNum in varchar2,
Name_in in varchar2)
as
begin
update 。。;
update ;commit;
end;
建job:begin
sys.dbms_job.submit(job => :job,
what => 'syndataeverynight;',
next_date => to_date('14-11-2008 02:35:37', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'SYSDATE+1');
commit;
end;报错“并非所有变量都已关联”
(IDNum in varchar2,
Name_in in varchar2)
as
begin
update 。。;
update ;commit;
end;
建job:begin
sys.dbms_job.submit(job => :job,
what => 'syndataeverynight;',
next_date => to_date('14-11-2008 02:35:37', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'SYSDATE+1');
commit;
end;报错“并非所有变量都已关联”
begin
sys.dbms_job.submit(job => :job,
what => syndataeverynight;',
next_date => to_date('15-11-2008', 'dd-mm-yyyy'),
interval => 'TRUNC(SYSDATE+1)');
commit;
end;
/
exec dbms_job.submit(:job1,'syndataeverynight;',to_date('14-11-2008 02:35:37', 'dd-mm-yyyy hh24:mi:ss'),'SYSDATE+1');
exec dbms_job.run(:job1);
变量没定义怎么用???
var job1 number;
begin
sys.dbms_job.submit(job => :job1,
what => syndataeverynight;',
next_date => to_date('15-11-2008', 'dd-mm-yyyy'),
interval => 'TRUNC(SYSDATE+1)');
commit;
end;
/