关闭连接会导致存储过程更改回滚

Question

关闭连接后，将回滚存储过程DeleteSproc执行的删除操作。这个代码怎么了

try:
    sql = '{CALL dbo.DeleteSproc (?,?,?,?,?,?,?,?)}'
    values = (c['brandId'],c['requestUuid'],c['registrationUuid'],i['tuid'],i['tpid'],c['status'],c['responseType'],i['BookingItemIds'])

    connBS = pyodbc.connect(l['connectionStrings'][0])
    cursorBS = connBS.cursor()
    rv = cursorBS.execute(sql, values)

    sql = '{CALL dbo.StatusProc (?,?,?)}'
    values = (c['requestUuid'],i['tuid'],i['tpid'])
    
    cursorBS.execute(sql, values)
    rows = cursorBS.fetchall()
finally:
    cursorBS.close()
    connBS.close()