CREATE OR REPLACE TRIGGER NOUVELLE_CARRIERE
    AFTER UPDATE OF SALAIRE, CODE_FONCTION, CODE_SERVICE
    ON SALARIE
    FOR EACH ROW
DECLARE
    v_begin_date DATE;
    v_current_date DATE;
    PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
    COMMIT;
    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
    SELECT CURRENT_DATE INTO v_current_date FROM DUAL;
    SELECT MAX(DATE_FIN) INTO v_begin_date FROM CARRIERES WHERE NUM_SALARIE = :OLD.NUM_SALARIE;
    INSERT INTO CARRIERES VALUES(:OLD.NUM_SALARIE, v_begin_date, v_current_date, :OLD.CODE_FONCTION, :OLD.SALAIRE, :OLD.CODE_SERVICE);
    COMMIT;
END;