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

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

是因为多了个冒号":"， 把sys.dbms_job.submit(job => :job,冒号去掉。

 

 

DECLARE job NUMBER;
begin
sys.dbms_job.submit(job => job,
what => 'PK_JOBS.cutMoAction;',
next_date => to_date('11-12-2010', 'dd-mm-yyyy'),
interval => 'TRUNC(SYSDATE + 1)');
commit;
end;
/