variable job1 number;
begin
sys.dbms_job.submit(
job => :job1,
what => 'PROC_SMS_1;',
next_date => trunc(sysdate, 'mi') + 1/(24*60),
interval => 'trunc(sysdate, ''mi'') + 1/(24*60)'
);
end;这个报错:ORA-01008:并非所有变量都已绑定;
请问是什么原因啊?请高人指点..
回复必给分;;
begin
sys.dbms_job.submit(
job => :job1,
what => 'PROC_SMS_1;',
next_date => trunc(sysdate, 'mi') + 1/(24*60),
interval => 'trunc(sysdate, ''mi'') + 1/(24*60)'
);
end;这个报错:ORA-01008:并非所有变量都已绑定;
请问是什么原因啊?请高人指点..
回复必给分;;
Declare job1 number;
begin
sys.dbms_job.submit(
job => job1, --不用:号进行在邦定吧
what => 'PROC_SMS_1;', ---这个过程在存在
next_date => trunc(sysdate, 'mi') + 1/(24*60),
interval => 'trunc(sysdate, ''mi'') + 1/(24*60)'
);
end; 测试