创建作业失败

Question

在PL/sql里面 执行job_num number; 
begin
  sys.dbms_job.submit( job_num,
                       '结转经销商进销存;',
                       to_date('16-07-2011', 'dd-mm-yyyy'),
                       'TRUNC(LAST_DAY(SYSDATE))+17+3/24');
  commit;
end;ORA-00900: 无效SQL语句
ORA-06550：第2行，第24列;
PLS-00201:必须声明标识符'job_num'
ORA-06550：第2行，第3列;
Pl/SQL:Statment ignored

Answer 1

declare         ---------缺少这里
job_num number;  
begin
  sys.dbms_job.submit( job_num,
  '结转经销商进销存;',
  to_date('16-07-2011', 'dd-mm-yyyy'),
  'TRUNC(LAST_DAY(SYSDATE))+17+3/24');
  commit;
end;

Answer 2

错误报的不是很明显么，要声明declare…