Second Sight (1989)

Wills is an ex-cop who pairs up with Bobby, a wacky psychic, to form the "Second Sight Detective Agency." Bobby's clairvoyant abilities come in handy during their investigations. When a nun recruits them for a case involving car theft, they suddenly find themselves dealing with the abduction of a prominent cardinal who has a chance of becoming the next pope. Bobby's psychic powers go haywire as they pursue the case.