Hi Experts,
Database version 11.2.0.4.0.
Suppose i have cursor query like this.
And cursor have 8000 records.
Cursor select_all is
Select col1,
col2,
col3,
......
.......
...upto..
col200
from some_table.
For Rec in select_all loop
Printing done here.
after printing 200 record it shows
ORA-06502 error (due to this error it is not printing the full 8000 records).
end loop;
I am also to find out which record has problem but not able to find out due to which column cursor gives error ORA-06502.
How to find out due to which column cursor gives error ?
Any tips really appreciated.