In my code i am fetching some records from a table and doing some task on the fetched data in a loop. I am doing it in try catch block.
Suppose 100 records are fetched by the query and processing is being done in a loop. now after processing suppose 20 records an exception occurs(SQL exception or any general exception due to wrong data in the record) while processing 21st. Then the execution of the loop will transfer to catch block. so next 80 records will remain unprocessed.
What I want is to continue the loop for processing next record instead of breaking it when exception occurs.
I am not sure it is possible or not. If it is then how to do it?
Thanx in advance.