A Canadian man was stabbed with a metal object while he shopped with family in eastern Saudi Arabia, police have confirmed.