Captain America is shown to not be able to get drunk.
With Spider-Man's body operating at even higher levels than Cap, has he ever been shown to be drunk?
This happened back in Web of Spider-Man #38(1988).
Peter is at a party and gets drunk, and ends up running off to fight the Hobgoblin.
After he almosts gets some innocents hurt, he pretty much swears off drinking.