In
Naming and Necessity, Saul Kripke writes that
The average person, according to this [theory], when he refers to Cicero, is saying something like "the man who denounced Catiline" and thus has picked out a certain person uniquely. It is a tribute to the education of philosophers that they have held this thesis for such a long time. In fact, most people, when they think of Cicero, just think of a famous Roman orator, without any pretension to think that there was only one famous Roman orator, or that one must know something more about Cicero to have a referent for the name.
In Chapter 4, "Vagaries of Reference", of
Word and Object, W.V.O. Quine does discuss Cicero, Tully, and the denunciation of Catiline by one or both. Quine argues that names in (for example) belief clauses are not referentially transparent, positing Tom, who is willing to affirm that Cicero denounced Catiline but not that Tully denounced Catiline. Evidently Tom was not a philosopher. But then one of the two epigraphs to
Word and Object is the quip "Ontology recapitulates philology."
Kripke mentions Sir Walter Scott a couple of times in
Naming and Necessity. Rudolf Carnap, setting out his language S1 in the first chapter of
Meaning and Necessity, includes the constants
s and
w, designating Walter Scott and Waverly, and predicate
Axy, meaning that
x is the author of
y. I suppose that the popularity of the example traces back to Bertrand Russell's 1905 essay "On Denoting."