I guess you may have drilled into a cable in the wall.
Your story suggests this but it could possibly be just that there's a wire adrift on the back face of the non-working socket outlet. Check for this first - otherwise it was your drill...
If this is the case the repair will require the skills of an electrician, a plasterer and a painter.
Peccavi, February 2009