Re: TO_NUMBER Problem

From: Eric Worthy <fast_johnnyz_at_yahoo_NO_SPAM_ME.com>
Date: Wed, 20 Feb 2002 09:21:37 -0700
Message-ID: <t2Qc8.4118$Kx5.46583@news.uswest.net>

I had this exact same problem.

I my code I had: column_name = 5. column_name always has a number in it. Well, this worked great in test environment. But when it went to production, the column_name
had some 2 rows that were not numeric. ('A', 'B'). So, Oracle couldn't convert it to a number...

Anyway, the point is that you always should use functions. Although it works in 1 db, it isn't
always going to work in another..

"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message news:330c88021a30f5fe987d183427e7f4aa.38849_at_mygate.mailgate.org...
> I am running the following code on an 8.1.6 database, and the join on
> two numeric fields (cal_year) only works with either a to_number or
> to_char function.
>
> However, when I run the same code against a clone of the database at
> 8.1.7, it works fine without the to_number/to_char function. Was there
> a bug that was resolved from 8.1.6 to 8.1.7, or is my code faulty?
>
>
Received on Wed Feb 20 2002 - 10:21:37 CST