关于job的问题 老是报并非所有变量都已经绑定 各位帮帮忙啊 在线等咯
~111 2011-06-23 10:56:07 create table student(name varchar2(20));
create or replace procedure my_pro(name1 varchar2) as
begin
insert into student(name) values(name1);
end;
declare myjob number;
begin
sys.dbms_job.submit(job=>:myjob,
what=>'my_pro(''smith'');',
next_date=>sysdate,
interval=>'sysdate+ 1/1440',
no_parse => false);
sys.dbms_output.put_line( 'success ');
commit;
end;