Okay. There are a number of versions of this tune. There are four of them given in ABC notation below and I hope one is the version you are looking for. To get the sheet music, copy one version and paste it into the ABC Convert-A-Matic at this address
http://www.concertina.net/tunes_convert.html. If one of them is the right tune, you can then print it up as a PDF file from there. I checked and they all work. But let me know if you have a problem.
Everything below is from The Fiddler's Companion
http://www.ibiblio.org/fiddlers/KA.htm
KATHARINE OGGLE/OGIE/OGGY. AKA and see "Catherine Logie," "Katherine Loggy," "Lady Catherine Ogle," "Ketrin Ogie," "Bonny Katherine Oggy." Scottish, Air. A Minor. Standard. AABB. The air, named after an unknown woman, was composed by Irish harper Rory dall O'Cahan, who lived in Scotland in the early 17th century. It appears earliest in the Scottish Panmure Manuscript #9454, c. 1675, Seventy Seven Dances, Songs and Scots Airs for the Violin, and was printed under this title in the Appendix to Playford's Dancing Master of 1686 (a note called it "a new dance"). On the strength of the Playford publication in the Dancing Master, 1686 edition, the English collector Chappell (1859) disputes the claim of Scottish ancestry. Chappell (1859), in fact, takes virulent exception to Stenhouse's scholarship regarding this tune after the latter claimed that the air was Scottish and dated it from the year 1680 (when it was sung by Mr. John Abell at a concert in Stationers' Hall). Chappell found that the only date Abell could possibly have sung it was in 1702, and he states that the earliest printing was in the Appendix to Playford's Dancing Master of 1686 (where it appears under the title "Lady Catherine Ogle"); Chappell, who claimed many Irish and Scottish airs as English, was evidently unaware of the version in the Panmure Manuscript when he accused Stenhouse of being deliberately misleading regarding its national origin. John Glen (1891) also disagrees with Chappell, noting that Chappell's own source, John Playford, published the tune a year before it was mentioned in The Dancing Master's appendix (1688) in Apollo's Banquet (5th edition, 1687) where it is called a "Scotch Tune" in footnotes and in fact appears under the title "A Scotch Tune" only. O’Farrell (c. 1806) also listed the melody as “Scotch.” It appears in one of the earliest Scottish fiddler's manuscript repertory books, c. 1705, in the private collection of Frances Collinson (1971). Early Scottish printed versions include the Guthrie Manuscript (c. 1675), the Leyden Manuscript (c. 1692) and it is included in the Gillespie Manuscript of Perth (1768). Later Scottish printings were in Orpheus Caledonius (1725 and 1733 editions). A popular song to the air was written (or rather reworked) by Thomas D'Urfey in his Pills to Purge Melancholy (1719-20) entitled "Bonny Kathern Loggy." Later versions of the air appear in The Merry Musician; or, A Cure for the Spleen (1716) and Ramsey's The Tea Table Miscellany. Published editions of ballad operas which include the tune are The Quaker’s Opera (1731), Polly (1729), The Beggar’s Wedding (1729), Pattie and Peggie (1730), The Lover’s Opera (1730) and The Highland Fair (1731). Later it was used by the poet Robert Burns as the vehicle for his song "Highland Mary" and appears in the Scots Musical Museum (No. 164). McGibbon (Scots Tunes, book II), c. 1746; pg. 44. Morison (Highland Airs and Quicksteps, vol. 2), c. 1882; No. 43, pg. 28. O’Farrell (Pocket Companion, vol. II), c. 1806; pg. 94. Flying Fish, Robin Williamson ‑ "Legacy of the Scottish Harpers, Vol. 2."
X:1
T:Katrin Ogie
L:1/4
M:4/4
K:Am
F|DGGG|AGG/2A/2c|AGA2|F3/2G/2AF|DGGG|AGGc|ddcA|G2A||\
c|dddA|cccG|AAAG|FGAF|DGGG|AGGc|ddcA|G2A|]
X:2
T:Cathrine Ogie
M:C
L:1/8
R:Air
S:O’Farrell – Pocket Companion, vol. II (c. 1806)
Z:AK/Fiddler’s Companion
K:A Minor
A>G | E2 A>B A3B | c2 B>A A2 B>c | d3e dB A>B | G3A B2 A>G |
E2 A>B A3B | c>d B>c A2 g>f | e2 d/c/B c>d B>c | A4 e2 :: AB |
c>d e>f g3a | g<e de g2 d>c | B2 g>e dB A>B | G3A (B/4c/2<d) c>B |
c2 (B>A/2B/4) A3E | A>Bc d2 {c/d/}e2 d>c | d>eg>a g<e dB | A4 e2 :|
X:3
T:Katharine Ogie
M:C
L:1/8
R:Air
N:”Slow”
S:McGibbon – Scots Tunes, book II, pg. 44 (c. 1746)
Z:AK/Fiddler’s Companion
K:A Minor
(A>G) | E2 (A>B) A3B | (c>d)(B>c) A2 (Bd/c/) | d3g (dB)”tr”(A>G) | G3A (G/A/B) “tr”A>G |
E2(A>B) A3B | (c>d)(B>c) A2 (a/g/f) | e2 (dc/B/) (c>d)(B>c) | “tr”A4e2 :: A>B |
(c>d(e>f) g3a | (ge)”tr”(dc) g2 (dc) | B2 (AB) (dB)(AB) | G3A (B/c/d) “tr”c>B | c2”tr”(B>A) A3E |
(A>B)(c>d) ({c/d/}e2) “tr”(d>c) | (de)(g>a) (ge)(dB) | “tr”A4e2 :: (a>g) | e2(a>b) a3b |
(c’/b/c’/)d’/ “tr”(b/a/b/>c’/ a2(bc’) | d’3c’ (b/d’/c’/b/ “tr”a>g | g3a (g/a/b) “tr”a>g | e2(a>b) a3b |
(c’/b/c’/)d’/ (b/a/b/)c’ a2 (a/g/f) | e2(dc/B/) (c/4d/4c/4B/4c/>)d/ (B/4c/4B/4A/4B/>)c/ |”tr”A4e2 :|
AB | c>d (e/d/e/)f/ g3a | (g/a/g/)e/ (g/e/)(d/c/) b2 “tr”d>c | (B/d/e/^f/ g)e (dB)(AB) | G3A (B/c/d) “tr”(c>B) |
(c/4/d/4c/4B/4c/>)d/ (B/4c/4B/4A/4B/>)c/ A3E | (AB) (c/B/c/d/) e2 “tr”dc | (de)(ga) g”tr”(f/e/) (d/f/e/)^G/ | “tr”A4e2 :|
X:4
T:Catherine Ogie
M:2/4
L:1/8
R:March
S:Morison – Highland Airs and Quicksteps, vol. 2, No. 43 (c. 1882)
Z:AK/Fiddler’s Companion
K:A Minor
e/d/ |: BA AG/A/ | BA AB/c/ | de/d/ BA/B/ | G>A Be/d/ | BA AG/A/ | BA Ag |
ag/e/ d/e/g/d/ | BA Ae/d/ :| de/^f/ gf/g/ | ae ea | g/^f/e/d/ e/f/g/B/ | G>ABe |
de/^f/ gf/g/ | ae ea | g/^f/e/d/ e/f/g/d/ | BA Ae/^f/ | de/^f/ gf/g/ | ae ea |
g/^f/e/f/ e/f/g/B/ | G>ABe | cB/c/ dc/d/ | e^f/g/ a>f | g/^f/e/d/ e/f/g/B/ | BA A2 ||
............
I have given up on the sheet music for The Red Rose Cafe. I know you said you couldn't learn things by ear (I'm not good at it either), but if you got so you could sing the words along with those fellows and you did that a lot of times so it was in your head totally, like you could whistle it, I bet you could get the tune from the recording. It is a neat recording and I was glad to learn about that song. I also came across a solo piping CD by Finbar Furey which I had been hoping to find, so I benefitted from the search---if I can find it again!