oracle触发器级联删除

create or replace trigger delete_trigger1
after delete on contracting_party 
 for each row
 begin
   if deleting then
    delete Account_Info
  where party_no=:old.party_no;
 end if;
end;
/

 

create or replace trigger delete_trigger2
after delete on contracting_party
  for each row
  begin
    if deleting then
     delete contracting_party_relation
    WHERE party_no=:old.party_no;
  end if;
end;