Re: Bet I can stump the "experts" with this one!!

Robert L Carter (rlc1_at_ritz.cec.wustl.edu) wrote:
: 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
:

DId your query have a WHERE clause? Did it select any other columns besides the varchar2 column?

Invalid Number could be anywhere; in the WHERE cluase (using a bad value on the right side i.e. WHERE OBVIOUS_NUMBER = 'x'), it could be an error in a view (a view that attempts to join a varchar2 and a number column, where one value in the varchar2 field is NOT a valid number), etc.

Joe

-- 
                                   
=---------------------------------------------------------------------------=
Joe Nardone <joe_at_access.digex.net> | I hate it when my schwartz gets twisted.  

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6.2

mQBtAzCg5QoAAAEDANvEmc4OAT8wntnCv8UPjyD2kohKVGa1CU21PLpYljzl3AE7
pldpNNscKSoE//aVMKYBO+tRFTTsPNi0qZ6CDlEBXTgJAiszoHh1qCzZyYj7FTBL
YoUr+3sk9rU8Pma6AQAFEbQiSm9lIE5hcmRvbmUgPGpvZUBhY2Nlc3MuZGlnZXgu
bmV0Pg==
=1ocE
-----END PGP PUBLIC KEY BLOCK-----