Heathcliff and the Catillac Cats (1984) : Hector the Detector

Hector answers a newspaper ad to become a private investigator and quickly becomes a nuisance to everyone; snooping around for clues to uncommitted crimes. After making a fool of himself several times, he realizes that a detective's life is not for him.