• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

wh0emPah on 04/02/10

Tagged

Versions (?)

04/02/10 03:24am

 / Published in: PL/SQL

 

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

Report this snippet   Tweet