F
ff_ff
Unregistered / Unconfirmed
GUEST, unregistred user!
SQL> declare
2 job_city_day2t_city_orders number;
3 begin
4 sys.dbms_job.submit(
5 job =>job_city_day2t_city_orders,
6 what=>'proc_city_date2t_city_orders;',
7 next_date=>sysdate,
8 interval =>'sysdate+1/1440'
9 );
10 commit;
11 end;
12 /
PL/SQL procedure successfully completed
SQL>
SQL> begin
2 dbms_job.run
job_city_day2t_city_orders);
3 end;
4 /
begin
dbms_job.runjob_city_day2t_city_orders);
end;
[red]ORA-01008: 并非所有变量都已绑定 [/red]
2 job_city_day2t_city_orders number;
3 begin
4 sys.dbms_job.submit(
5 job =>job_city_day2t_city_orders,
6 what=>'proc_city_date2t_city_orders;',
7 next_date=>sysdate,
8 interval =>'sysdate+1/1440'
9 );
10 commit;
11 end;
12 /
PL/SQL procedure successfully completed
SQL>
SQL> begin
2 dbms_job.run
job_city_day2t_city_orders); 3 end;
4 /
begin
dbms_job.run
job_city_day2t_city_orders); end;
[red]ORA-01008: 并非所有变量都已绑定 [/red]