ORA-01008: 并非所有变量都已绑定

今天进行迁移数据库的时候，迁移job，总是出错。

DECLARE job NUMBER;
begin
  sys.dbms_job.submit(job =>:job,
                      what => 'docontractreports;',
                      next_date => to_date('05-11-2010', 'dd-mm-yyyy'),
                      interval => 'trunc(sysdate, ''HH24'') + 1/2');
 SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(job));                     
  commit;
end;
/

ORA-01008: 并非所有变量都已绑定

经查询,是因为多了个冒号" : "， 把冒号去掉就ok 了。
改正后

DECLARE job NUMBER;
begin
  sys.dbms_job.submit(job =>job,    --注意：此处没有冒号了
                      what => 'docontractreports;',
                      next_date => to_date('05-11-2010', 'dd-mm-yyyy'),
                      interval => 'trunc(sysdate, ''HH24'') + 1/2');
 SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(job));                      
  commit;
end;
/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/3090/viewspace-677581/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/3090/viewspace-677581/