Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: data type conversion in 10g
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 PM
To: Elliott, Patrick; oracle-l_at_freelists.org
Subject: 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 10g
Date: Tue, 3 Jul 2007 13:24:58 -0500
From: patrick.elliott_at_medtronic.com
To: 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>
To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 03 2007 - 13:49:08 CDT