求助 触发器！

Question

CREATE OR REPLACE TRIGGER A_U  BEFORE
UPDATE OF "ISDELETE" ON A表 FOR EACH ROW 
declare 
  newisdelete varchar2(1);
  oldisdelete varchar2(1);
  newdeletedate varchar2(20);
pragma autonomous_transaction; 
begin
  newisdelete:=:new.isdelete;
  oldisdelete:=:old.isdelete;
  newdeletedate:=:new.deletedate;
  if newisdelete='1' then
    update A表  set isdelete='1' where fparentid=:new.folderid;
     commit; ----这里的提交很重要
  end if;  
end;

Answer 1

晕  自己回答还不能结贴！

Answer 2

来接个分