create or replace trigger order2_trig 

before insert on order2

for each row

begin

total_cost :=:new.quantity * :new.price;

end;

 

Warning: Trigger created with compilation errors.

----------------------------------------------------------------------------------------------------

create or replace trigger stock_trig 

after

insert on order2

for each row

begin

update stock

set quantity = quantity - :new.quantity

where item_id = :new.item_id;

end;

 

 

 

Warning: Trigger created with compilation errors.

 

change it to before insert 

 

references to :new and :old must be before DML operation

 

Best Regards

 

 

create or replace trigger order2_trig 

before insert on order2

for each row

begin

total_cost :=:new.quantity * :new.price;

end;

 

Warning: Trigger created with compilation errors.

----------------------------------------------------------------------------------------------------

create or replace trigger stock_trig 

after

insert on order2

for each row

begin

update stock

set quantity = quantity - :new.quantity

where item_id = :new.item_id;

end;

 

 

 

Warning: Trigger created with compilation errors.

 

 

حط السطر التالي بعد الـ Trigger

 

/

SHOW ERR

 

 

 

 

Create or replace trigger stock_trig 

after

insert on order2

for each row

begin

update stock

set quantity = quantity - :new.quantity

where item_id = :new.item_id;

end;

/ 

SHOW ERR

 

حتعرف رقم الخطأ ووصفه

 

change it to before insert 

 

references to :new and :old must be before DML operation

 

Best Regards

 

Warning: Trigger created with compilation errors

after is necessary in that trigger

but referencing where write it

?and why

أنا جربتها قبل كده وكانت شغالة معايا لكن مكانش بيديني الارور ده

تم تعديل 27 أبريل 201312 سنة بواسطة منمون علي