Hello,
I am trying to execute the SQL statement
SQL > select * from mytable where col1 = 1234438;
col1 is varchar2(20).
The query works and retreives the records on the development environment; whereas it gives an error ORA 1722 - invalid number in the test environment. It works fine if the value is enclosed in quotes.
I would like to know what could be different between the two environments?
Any input on this is greatly appreciated.
Thanks in advance.
I am able to perform the query on other varchar2 columns; it is failing only on this column.
- Thanks
[Edited by hedyash on 01-26-2001 at 03:03 PM]