DELIMITER $$
CREATE TRIGGER trg_advertisements_before_iu
    BEFORE INSERT OR UPDATE
    ON advertisements
FOR EACH ROW
DECLARE
    CURSOR c_contract
    IS
        SELECT website_id, POSITION
          FROM contracts
         WHERE id = :NEW.contract_id;

    DECLARE v_website_id         VARCHAR2 (200);
    DECLARE v_position           VARCHAR2 (200);

BEGIN
    OPEN c_contract;

    FETCH c_contract
      INTO v_website_id, v_position;
    CLOSE c_contract;



    SET @:NEW.website_id = v_website_id;
    SET @:NEW.POSITION = v_position;
END;
DELIMITER ;