Re: ORDERED_PREDICATES: puzzling enigma here

From: Spendius <spendius_at_muchomail.com>
Date: 12 May 2005 00:07:26 -0700
Message-ID: <aba30b75.0505112307.2f88a09c@posting.google.com>

Yes but HOW COME putting the hint rids you from this error ???

I could understand if ZIP contained somewhere AB987 or CA345 and that putting the hint filtered them out first, but in this case the remaining values in ZIP are "clean" from this point of view (actually all ZIP values are clean from this numeric point of view): so what makes Oracle reject them first, and then accept them with this hint ? "zip = 43933" is wrong anyway, whatever the result set is pre-filtered or not !

"Mark D Powell" <Mark.Powell_at_eds.com> wrote...
> The invalid number error is because of the implicit conversion of the
> zip varchar2 column to numeric data because you requested Oracle to
> compare a character column to a number via "zip = 43933" when you
> should have coded "zip = '43933' "
>
Received on Thu May 12 2005 - 02:07:26 CDT