Posted By

wh0emPah on 04/02/10


Tagged


Versions (?)

azeraz


 / Published in: PL/SQL
 

  1. CREATE OR REPLACE TRIGGER P6_3_ORDERFILLED2
  2. BEFORE UPDATE ON s_ord
  3. FOR EACH ROW
  4. IF (:OLD.order_filled = 'Y') THEN
  5. RAISE_APPLICATION_ERROR(-20000, 'Dit order is al afgewerkt!');
  6. END P6_3_ORDERFILLED2 ;

Report this snippet  

You need to login to post a comment.