JOB创建好了,然后手动执行就报错这是我JOB创建的语句
begin
sys.dbms_job.submit(job => :job,
what => 'update fb_p_base dd
set dd.c13 =
(select jd
from pkgk.vw_fb_zxjdgx aa
where dd.prj_code = aa.prj_code
and dd.set_year = 2018
and dd.batch_no = 1
and dd.data_type = 0);',
next_date => to_date('14-11-2017 12:45:56', 'dd-mm-yyyy hh24:mi:ss'),
interval => '(SYSDATE+1)');
commit;
end;
/
麻烦各位帮忙看下,哪里有问题
begin
sys.dbms_job.submit(job => :job,
what => 'update fb_p_base dd
set dd.c13 =
(select jd
from pkgk.vw_fb_zxjdgx aa
where dd.prj_code = aa.prj_code
and dd.set_year = 2018
and dd.batch_no = 1
and dd.data_type = 0);',
next_date => to_date('14-11-2017 12:45:56', 'dd-mm-yyyy hh24:mi:ss'),
interval => '(SYSDATE+1)');
commit;
end;
/
麻烦各位帮忙看下,哪里有问题
在过程和job中调用的权限都需要显示赋予。