trigger如下,编译通不过,提示:无效的触发器说明,问题出在那里? create or replace trigger tszl_trigger AFTER insert or update on tszl_tgsh,tszl_tsjcsj FOR EACH STATEMENT declare job_id integer; begin dbms_job.submit(job_id,'proc_insert(''10'',''1'',''1'');',to_date('6.12.06 12:00:00','mm.dd.yy hh24:mi:ss'),'sysdate+12'); commit; end;
create or replace trigger tszl_trigger
AFTER insert or update on tszl_tgsh,tszl_tsjcsj
FOR EACH STATEMENT
declare
job_id integer;
begin
dbms_job.submit(job_id,'proc_insert(''10'',''1'',''1'');',to_date('6.12.06 12:00:00','mm.dd.yy hh24:mi:ss'),'sysdate+12');
commit;
end;