Originally posted by slimdave haaif.attribute3 contains strings that cannot be converted to numbers
Most obvous answer. However: how come the same SQL executes fine without PARALLEL hint, as the original poster indicates (if this is actualy true)? It smells more as a bug to me, if what original poster states is true....
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Originally posted by jmodic Most obvous answer. However: how come the same SQL executes fine without PARALLEL hint, as the original poster indicates (if this is actualy true)? It smells more as a bug to me, if what original poster states is true....
Or it could be something like.. the order in which the tabs are accessed & joins and so.
What i mean is something like..
Case I ( Without parallel hint ) :
lets assume the table haaif is the driving table (& in exec plan too)and is driven by some other condition & not 'attribute3' (or even 'attribute3' also as we dont know what the other conditions are).. and all the values returned for 'attribute3' is only Numerals..
Case II ( With parallel hint )
lets assume here plan is slightly diff from above one.. & haaif is not the driving table.. we will assume papfa is the driving table & for some person id there is a value in haaif where attribute3 is non numeral.. so for that Val, it suerly errors.
So not necessarly a bug ..
PS jurij, you can blast if i have some where mistaken in concepts
Last edited by abhaysk; 04-07-2004 at 10:53 AM.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
I think, you are right. Because, in following case, I am running the 1st select statement without parallel in it and it still failing with invalid number error. but in second, it is not failing when using decode statement.
select attribute3,to_number(attribute3) from hxc_time_attributes
select attribute3,to_number(decode(attribute3,'NA',NULL,attribute3)) from hxc_time_attributes
To handle yourself, use your head. To handle others, use your heart