Thanks jmodic for your solution it helped me allot.

What if the error ORA-01555 comes even when
i am not updating the table for which i have opened the cursor.

like cursor for "trn" table of 28 lac rows
based on its fetched row
i am updating another table like "closing_balance"