how to check which value is causing SQL Error: ORA-01722: invalid number
<p>Getting SQL Error:</p>
<blockquote>
<p>ORA-01722: invalid number in Insert SQL.</p>
</blockquote>
<p>How to check which line or which value is causing this error because it does not give exact line number. SQL is having more than 200 values. Below message it gives 133 is starting line number of SQL.</p>
<blockquote>
<p>Error starting at line : 133 in command - INSERT INTO TABLE1..... . .</p>
<p>SQL Error: ORA-01722: invalid number</p>
</blockquote>