Hi! Which kind of error? And where does it occur? What's the view code?
Oracle does an implicit datatype conversion (if possible) when comparing different datatypes. Try to add the conversion explicitly with to_number for example & try then. Note that Oracle can't use indexes in joins for implicitly or explicitly converted data - unless you have relevand function based indexes there... So, you might have problem in your design. Btw, did you change any versions recently? If you just went to 9.2.0.3 or 9.2.0.4, and started seeing your problem after that, then you might want to look at event 10499 on level 1 which is new starting from 9.2.0.3. (I doubt that you are hitting this problem, you didn't give us enough information). Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 11:49 PM > I don't know what to think re. this. > > There is a view here that produces an error, I identified why -- in one AND > clause a number(9) datatype column is being joined with a varchar2(50) > datatype column. > > The developer of this code says that this used to run, there must be > something wrong with the server. > > I want to verify... Is there any kind of overloading invoked automatically > when Oracle compares columns of different datatypes? > > i.e. if the varchar2(50) column only contains numbers, would Oracle convert > it automatically to number before making the comparison? > > (My intuition says: NO. ) > > Patrice. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
