mqiojfei

CREATE OR REPLACE TRIGGER P6_7_TRIGGER2 BEFORE
  INSERT OR UPDATE OF ORD_ID ON s_item 
  FOR EACH ROW 
BEGIN 
  FOR I IN 1..P5_summit_pkg.t_totord.COUNT 
  LOOP 
  IF(summit_pkg.t_totord(i).ord_id = :NEW.ord_id) THEN 
    IF (P5_summit_pkg.t_totord(I).total >= 10) 
      THEN RAISE_APPLICATION_ERROR(-20000, 'max 10 items per order!');
    END IF;
  END IF;
END LOOP;
END P6_7_TRIGGER2 ;