What is the difference between the slang terms 'erection' and 'horny'?

Erection is not a slang term. It means that the penis is erect.

Horny IS a slang term. It means you are in the mood for sex.