How do I get column name that causing the error ORA-01722: invalid number
728153Jun 2 2010 — edited Jun 2 2010I am using PreparedStatement for inserting data into a large table with 50 columns through a Java/J2EE web application using Spring JDBC Template. The error message is "*ORA-01722: invalid number*" .
The database is Oracle Database 10g Enterprise Edition Release 10.2.0.3.0.
The error message doesn't say which column is having the issue. It is very difficult to locate the issue with the data for a large table. I tried the same statement with SQL Plus but there was no change.
As I have read from the previous blogs that Oracle 10g gives the exact error.
Please let us know if there is a way to pinpoint the column.