can someone tell me how to avoid this mutating table error (ORA-04091) I have to use a After Update Trigger for this homework.
AFTER UPDATE OF QTY,ACTUALPRICE ON ITEM
FOR EACH ROW
DECLARE
BEGIN
UPDATE ITEM
SET ITEMTOT = :new.QTY * :new.ACTUALPRICE
WHERE ORDID = :old.ORDID AND ITEMID = :old.ITEMID;
END;