| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: data type conversion in 10g
We have mix of number values and char values in the column. Once I delete all char values in the column, 'where test1<88' works in 10g, too.
David
Subject: RE: data type conversion in 10gDate: Tue, 3 Jul 2007 13:49:08 -0500From: patrick.elliott_at_medtronic.comTo: davidb158_at_hotmail.com; oracle-l_at_freelists.org
I am extremely curious. What is the data that is causing this?
Pat
From: David Boyd [mailto:davidb158_at_hotmail.com] Sent: Tuesday, July 03, 2007 1:40 PMTo: Elliott, Patrick; oracle-l_at_freelists.orgSubject: RE: data type conversion in 10g First thanks for all of you who replyed to my mail. Our NLS parameters are the same in both 9i (9.2.0.6) and 10g. As I replyed to Tom's mail, the data in 9i and 10g are the exactly same. David
Subject: RE: data type conversion in 10gDate: Tue, 3 Jul 2007 13:24:58 -0500From: patrick.elliott_at_medtronic.comTo: davidb158_at_hotmail.com; oracle-l_at_freelists.org
The problem isn't with 10g, it is with your NLS parameters and/or the data. The error comes from the values in the column not from your 88. The 88 converts fine to a number, but the values in your column do not. Any non-numeric values in the column will cause this.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 03 2007 - 14:25:06 CDT
 |
 |