The player is quite new to the system. For a balanced group I would much rather have him play a cleric.
I really can't offer much advice here, save to say that Cleric is very, very unfriendly to someone new to the D20/PF system. If you really need that role filled, nudge him toward a Life Oracle instead of Flames.
Limited spell slection is not a big deal for divine casters. Becous the list only hase a few must have spell at each level. Oracles gain cure/inflict of any level they can cast in addition to there spells known and mystery spells.
I recomend going Wind if he wants to go caster oracle. It is much more versatal with what you can do with it. With abilitys like Gaseous Form (Su), Invisibility (Su), and Air Barrier (Ex).
The other one at the top of my list for a casting oracle time. You get a very nice casting list. memory lapse(2nd), gentle repose(4th), sands of time(6th), threefold aspect(8th), permanency(10th), contingency (12th), disintegrate(14th), temporal stasis(16th), time stop(18th). Then you get powers like. Aging Touch (Su), Erase from Time (Su), Time Sight (Su), Time Hop (Su).
If he is a new player he might not know that direct damage spells are a wast of casting power. That might be what he is thinking. If he hase played mmorpg thats probly the case.
What stats are you using? Over all min casting stat base of 17 followed by con. If your doing time you will need some str or dex for touch attacks.
My personl pick for a casting oracle.
Time > Wind > Heavens > Lore > Life
A paladin, a bard, and a celestial sorc can all heal. Healing won't be a problem, especially since the oracle can also heal. The bard and oracle can tag team the buffing role. There's no reason a flame oracle couldn't work.
My wife's PFS character is an 8th-level flame oracle. Don't let the haters fool you: at the middle levels, blasting spells can be quite effective. My wife's oracle stays out of reach by using a longspear. She's something like 14 STR, 18 CHA, other stats to taste. With bull's strength she turns into a real threat. If the bad guys get too close, she can run away quickly using cinder dance.
I don't hate im a realist. You can do much more damage with a melee weapon then you can with any spell. Wind hase more over all abilitys then just DPR. Thats why I rank it higher. Time is just so good to pass up with a ton of specal abilitys and spells.
Level 10 DPR Fighter is at 100+ Damage a round
Level 10 caster fire ball/lighing bolt DPR 35 to a area that you need a min of 3 targets in to do the same damage as a fighter.
So yes at below level 10 DPR with spells is ok. After level 10 with energy resistands and spell resistance. It is not so good any more.
You need to think of making the character good for all levels of play. Plan the character for
low 1-5(None focused AC counts. Spell DCs are high enough for saves. With out focus. Low DPR will not hurt very much. Low HP characters don't have meny problems.)
mid 6-10 (None focused AC starts being point less. None focused spell DC are to low. Low DPR will start hurting. Low HP characters will die a few times.)
high 11-20 (None specialized AC is a wast of time. None specialized spell DCs will never be high enough. Low DPR partys will have to plan a head for every encounter. Low HP characters will need to carry exta scrolls of rase dead.)
The problem is “Shadows of Gallowspire,” a Pathfinder RPG adventure for 13th-level characters. So your ending level will be 14 - 15. At this level it's easy to tell who did not plan out there characters very well.
Just a example pulled at random. Starting base casting stat of 20.
Bebilith CR 10
Fort +15, Ref +11, Will +7 (Will being the easy save to effect. Ability+8 Spell level 1 DC 19 spell level 5 DC 24)
bite +19, and 2 claws +19
Horned Devil (Cornugon) CR 16
Fort +18, Ref +17, Will +13 (Will being the easy save to effect. Ability +10 Spell level 1 DC 21 Spell level 28.)
+1 unholy spiked chain +26/+21/+16, bite +22, tail +22, or 2 claws +24, bite +24, tail +22