Sayyiduna Abdullah bin Abbas (may Allah be pleased with them both) narrated that the Prophet (peace and blessings be upon him) did not fix any prescribed punishment for wine. He narrated that a man drank wine and became intoxicated; he was staggering about in the road. People were taking him to the Prophet (peace and blessings be upon him). When he came level with the house of Sayyiduna al-Abbas (may Allah be pleased with him), he broke free, went in to Sayyiduna al-Abbas (may Allah be pleased with him) and clung to him. When this was mentioned to the Prophet (peace and blessings be upon him), he (peace and blessings be upon him) smiled and said: "Did he really do that?" And he (peace and blessings be upon him) gave no order concerning him.
Hadith Referenceالسنن الكبرى للبيهقي / كتاب الأشربة والحد فيها / 17509