CREATE OR REPLACE TRIGGER PRE_UPD_PRODUCT
BEFORE UPDATE ON PRODUCT
FOR EACH ROW
PRICE_TOO_LOW EXCEPTION;
IF :NEW.SALE_PRICE < :NEW.STORE_COST THEN
RAISE PRICE_TOO_LOW;
EXCEPTION
WHEN PRICE_TOO_LOW THEN
RAISE_APPLICATION_ERROR(-2000,'Raise price');
/