Could this be possible that when the cursor was opened with that table data it locked the table and so the insert on the same table was not possible and so everthing looked dead...

thanks
Sonali