Due to hardware failure after a power outage we had to recreate the database for one of our 3rd party applications from an dumpfile (created via exp). The old hardware had Oracle 10G R2 running while the new hardware is running Oracle 11G R2. Everything went smoothly and the application ran normally again.
The last few days our users reported problems with the software. After some research the application runs a sql statement which tries to filter a varchar column with a number thereby forcing an implicit conversion of the column.
In the previous version of Oracle everything went fine but now an "ORA-01722: invalid number" is thrown.
Might there be some setting we have missed for the new database?
We already contacted the developing company but it will take some time.
Sample table and data:
create table conversion (
col1 varchar2(10)
);
insert into conversion values ('test2');
insert into conversion values ('42');
insert into conversion values ('test3');
Simplified statement throwing the error:
select count(*) from conversion where col1 = 42;
Thanks in advance and best regards
Jan