Charms fail burglar as he was caught sleeping and snoring after robbery operation