Re: ORA-01722 - Invalid Number

The ID column is character format, thus

where ID = 123

is an implicit

where to number(ID) = 123

and some of the ID's are probably non-numeric

hth
connor

-- 
=========================
=====
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
  "Hussein METDAOUI" <hmetdaoui_at_eyrolles.com> wrote in message 
news:3B2647FF.5105DFF1_at_eyrolles.com...
  Hi ! 
  I've found a bad query in a web site : 
  select * from table where id=1321313 ...... without quote :-) 
  Before today this runs. 

  Now each time i use this kind of query an error occurs : 
  ORA-01722 -Invalid Number 

  No changes have been done to the database before that. 
  Now i've corrected the query  : select * from table where 
id='1321313' and it runs. 

  Anyone knows this problem ? 

  Thanks...... 

  Apache/PHP3/Oracle 8.0.5 under Linux 6.2 


--