-- DELIMITER //

CREATE PROCEDURE $procName(IN v_start VARCHAR(100), IN v_end VARCHAR(100))
    LANGUAGE SQL
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''

    BEGIN
        START TRANSACTION;
            DELETE FROM audit_bet_transactions WHERE settlement_date_time BETWEEN v_start AND v_end;
        COMMIT;
    END;
-- //