How do I turn off implicit data conversion on Oracle DB?
Posted on 2007-11-15
A table has a column defined as varchar2(30) type.
A query is being executed against this table as follows:
select * from sv_query where user_id=18612308;
This works in all envrionments except for production.
In production, the query is failing with the following error message:
ORA-01722 : Invalid Number