oracle的存储过程和定时任务编写体会

create or replace procedure clear_product is

p_sql char(200)

p_r_sql char(200)

begin

   p_sql := '';

   p_r_sql :='';

   execute immediate p_sql;

   execute immediate p_r_sql;

   commit;

end clear_product;

declare

job number :=1

begin

dbms_job.submit(job,'此处填存储过程含函数','sysdate',‘此处见定时任务属性’)

commit;

end;

/