oracle job该怎样创建?一个简单的job一致报语法错误。create or replace procedure test is
begin
dbms_output.put_line('tesd');
end test;
declare
v_job number(4);
begin
sys.dbms_job.submit(v_job,'test',sysdate,'sysdate+1/1440');
end;执行上面的job一直报错,ora-06550.求教!!!
begin
dbms_output.put_line('tesd');
end test;
declare
v_job number(4);
begin
sys.dbms_job.submit(v_job,'test',sysdate,'sysdate+1/1440');
end;执行上面的job一直报错,ora-06550.求教!!!
v_job number(4);
begin
sys.dbms_job.submit(v_job,'test;',sysdate,'sysdate+1/1440');
end;