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]