azeraz

CREATE OR REPLACE TRIGGER P6_2_ORDERFILLED BEFORE
  INSERT OR UPDATE OF order_filled  ON s_ord 
  FOR EACH ROW 
  DECLARE 
    v_ordlines NUMBER;
  BEGIN
    SELECT COUNT(ord_id) 
    INTO v_ordlines 
    FROM s_item 
    WHERE ord_id = :NEW.id;
    IF v_ordlines = 0 THEN
      RAISE_APPLICATION_ERROR(-20000, 'Order moet eerst orderlijnen bevatten!');
    END IF;
  END P6_2_ORDERFILLED;