Re: Bet I can stump the "experts" with this one!!
Date: 1995/11/13
Message-ID: <486pdq$664_at_ccnet2.ccnet.com>#1/1
> rlc1_at_ritz.cec.wustl.edu (Robert L Carter) writes:
hth - Claude
Received on Mon Nov 13 1995 - 00:00:00 CET
> For the last four months I've been using a certain table which I update and
> select from on a day to day basis. Yesterday, when tring to do a select on a
> varchar2 column I got an oracle error saying invalid number, thats fine and
> well, but how do I get rid of this invalid number if oracle will not even
> let me "see" it. Anyone know an easy fix, any ideas?!
>
> -Rob
>
>
>>>>
Often Oracle will do an implicit conversion when you have failed to make it
explicit. If you have set a number field equal to a string in the where clause
(or vice-cersa - a string to a number) Oracle may try to convert a string
to a number where you don't want this and report an error. Of course,
including the SQL and which portion Oracle reported the error for would help
a hell of a lot also!!