Announcement Announcement Module
Collapse
No announcement yet.
How do I get column name that causing the error ORA-01722: invalid number Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do I get column name that causing the error ORA-01722: invalid number

    I am using NamedParameterJdbcTemplate PreparedStatement for inserting data in Oracle Database 10g Enterprise Edition Release 10.2.0.3.0.
    The tables are huge and if there is any data issue for a column like ORA-01722: invalid number, it is very difficult to find the column as the error message doen't show the bind variables or highlight the column.

    Is there is a way by which the error message can show the bind variables also or show the column for which there is a data issue.
Working...
X