ORA-01722: invalid number: Identify data causing invalid number error.
Posted on 2011-10-21
The error is comming from the following statement.
insert into table2 (abc,
from view1 a
inner table2 x
on x.col1 = a.col1
and x.col2 = a.col2
inner join table3 mil
on mil.col1 = a.col1
and mil.col2 = a.col2
and mil.col3 = a.col3
where x.col1 = 'ABC'
and mil.col1 = 180;
Table from a view is being inserted into a table.
The select statement retrieves 4,500 rows.
However, i do not have the privileges to run this statement to pinpoint which row from the view is causing the error.
This is because I am checking into UAT on which i have only read access.
In such a case how do i identify the data causing the error?