ناتج تنفيذ هذا ال  trigger    يعطى الخطأ التالى

3/1      PL/SQL: SQL Statement ignored
4/46     PL/SQL: ORA-00933: SQL command not properly ended
22/18    PLS-00103: Encountered the symbol "=" when expecting one of the
         following:
         := . ( @ % ;

24/1     PLS-00103: Encountered the symbol "ELSIF"

 

ارجو المساعده فى حل هذا الخطأ

والترجر هو

create or replace trigger mytri
after
insert or update or delete
on  moshtrawat
for each row
begin
if inserting  then
update storesasnaf set
quantity = quantity + nvl ( :new.quantity,0)
unit_price_clint = :new.unit_price_clint
where snum = :new.snum;
elsif updating ('snum') then
update storesasnaf set
quantity = quantity-nvl(:old.quantity,0)
where snum = :old.snum;
update storesasnaf set
quantity = quantity + nvl ( :new.quantity,0)
where snum = :new.snum;
elsif updating ('quantity') then
update storesasnaf set
quantity = quantity-nvl(:old.quantity,0)
where snum = :old.snum;
update storesasnaf set
quantity = quantity + nvl ( :new.quantity,0)
where snum = :old.snum;
elsif updating ('unit_price_clint')  then
unit_price_clint = :new.unit_price_clint
where snum = :old.snum;
elsif deleting then
update storesasnaf  set
quantity = quantity-nvl(:old.quantity,0)
unit_price_clint = null;
where snum = :old.snum;
end if;
end;

حط فاصله في الجزء دا وجرب

elsif deleting then
update storesasnaf  set
 ,quantity = quantity-nvl(:old.quantity,0) 
unit_price_clint = null;
where snum = :old.snum;
end if;
end;

تم تعديل 11 يوليو 201312 سنة بواسطة HELL-BOY