select * from gen_prop_information_tab where txt_policy_no_char = 0100010280 giving error ora-01722: invalid number in production database where as the same query gives output in other databases. column txt_policy_no_char is varchar2(30). The data count in Production is more as compared to other database.
When the same query is executed as select * from gen_prop_information_tab where txt_policy_no_char = '0100010280', it fetches data in all the databases including production.
Please help in identifying the reason and solution for it. Oracle database version is 11.2.03
Thanks & Regards,
Mukesh