RE: data type conversion in 10g

From: David Boyd <davidb158_at_hotmail.com>
Date: Tue, 3 Jul 2007 14:40:19 -0400
Message-ID: <BAY137-W224D218F493F204BDD1EACEF0C0@phx.gbl>

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.  

Pat

---

Local listings, incredible imagery, and driving directions - all in one place! Find it! http://maps.live.com/?wip=69&FORM=MGAC01

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 03 2007 - 13:40:19 CDT