Posted By

wh0emPah on 04/02/10


Tagged


Versions (?)

mqiojfei


 / Published in: PL/SQL
 

  1. CREATE OR REPLACE TRIGGER P_6_5_QUANTITYCHECK AFTER
  2. UPDATE OR INSERT ON s_item
  3. FOR EACH ROW
  4. IF(:NEW.quantity_shipped > :NEW.quantity) THEN
  5. RAISE_APPLICATION_ERROR(-20000,'Quantity Shipped kan niet meer zijn dan quantity');
  6. END P_6_5_QUANTITYCHECK;

Report this snippet  

You need to login to post a comment.