CREATE OR REPLACE TRIGGER GRAVA_IDITMCONS
BEFORE UPDATE OF NRSOLCMPCONS
ON ITEMSOLI FOR EACH ROW
BEGIN
  IF :NEW.NRSOLCMPCONS IS NULL THEN
    :NEW.IDITMCONS := 'N';
  END IF;
END;
/