Failed first time

A few months ago I was on a date and it was going to lead to sex but when she mentioned it I panicked as a virgin. The previous night I had lots to drink so this would have had been bit of the problem. I panicked essentially and couldn’t maintain a full hard on for sex and I was really nervous aswell like really nervous. So we never had sex and she left and now I am terrified about what will happen next time I have a sexual encounter. So now I pretty much avoid it which hurts me