There's a famous narration regarding wine which says the prayer of its imbiber will not be accepted for forty days! (Mustadrak al-Wasa'il, Vol. 17, P. 57) However it is worthy to know that there's another sin which is worse than…
قال رسول الله صلی الله علیه و آله و سلم:
مَنْ شَرِبَ خَمْرا خَرَجَ نُورُ الاِیمانِ مِنْ جَوْفَهِ.
The Messenger of Allah (S) said:
Whoever drinks wine, the light of faith will abandon his heart.
Kanzul Ummal, Vol. 5, T. 13180