I got this error when I was doing a massive insert/update on a table (merge). The procedure has multiple procedures with in itself which involves truncating the temp tables, fetching data into temp tables and the some transformations on temp tables before insert/updating the target table..
When I re-ran the procedure again, the error didnt occur..
So what are the circumstances this error occurs? How to catch the erroneous rowid when the error occurs..