Posted By

wh0emPah on 04/02/10


Tagged


Versions (?)

mqiojfei


 / Published in: PL/SQL
 

  1. TRIGGER P6_6_VERHOOG_TOTAL_IN_STOCK
  2. AFTER
  3. INSERT ON s_inventory
  4. FOR EACH ROW
  5. v_verhoging NUMBER(10);
  6. IF (updating) THEN
  7. v_verhoging := :NEW.amount_in_stock - :OLD.amount_in_stock;
  8. ELSE IF (inserting) THEN
  9. v_verhoging := :NEW.amount_in_stock;
  10. P5_summit_pkg.verhoog_total_in_stock(:OLD.product_id,v_verhoging);
  11. END P6_6_VERHOOG_TOTAL_IN_STOCK;

Report this snippet  

You need to login to post a comment.