This is usually used in the context of public speaking, for example you are asked to make a speech and you can't think of anything to say. You might tell someone "I dried up completely. It was so embarrassing."

This can have different meanings, depending on the context. It can mean a girl cannot have sex because her vagina is dry. Essentially, I need more information (context) to give you a proper answer.