There are two tunes. Burns originally set it to Rory Dall's Port, but it was later set to Hi Oro 'S Na Horo Eile and seems usually to be sung to that tune nowadays; probably most people learn the song from records rather than books. More details in thread Haunted by a song (second half).

I don't think that the questioner intended a translation, but had just misunderstood the phrase; easily done in the circumstances.