在PL/SQL中执行下面语句:
begin
sys.dbms_job.submit(job => :job,
what => 'ClearAMSData;',
next_date => to_date('07-01-2010 03:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1');
commit;
end;
/
结果报错:“ora-01008 并非所有的变量都已绑定”,这是怎么回事?这个语句是我用PL/SQL手动设置生成的脚本,我把它拷出来在另外一个环境中执行,结果报错!
begin
sys.dbms_job.submit(job => :job,
what => 'ClearAMSData;',
next_date => to_date('07-01-2010 03:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1');
commit;
end;
/
结果报错:“ora-01008 并非所有的变量都已绑定”,这是怎么回事?这个语句是我用PL/SQL手动设置生成的脚本,我把它拷出来在另外一个环境中执行,结果报错!
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
i_jobnum number(10);
begin
dbms_job.submit(i_jobnum,
'ClearAMSData;',
to_date('07-01-2010 03:00:00', 'dd-mm-yyyy hh24:mi:ss'),
'sysdate+1');
commit;
end;
/
dbms_job.submit(:job1,''ClearAMSData;',to_date('07-01-2010 03:00:00', 'dd-mm-yyyy hh24:mi:ss'),'sysdate+1');
end;
/