Thank you James.

But my cursor depends on different table suppose (main_table). and I want to find dependency of table read from main_table. And I am storing it into another table. I will try to do UPDATE in one statement and making cursor READ_ONLY. But i do not think its because of the lock on cursor.