Can anybody please let me know the purpose of using the statement INSENSITIVE SCROLL CURSOR FOR while declaring the cursor?
one issue was found in our program and our onsite told the following reason:
Quote:
we got an issue where we have a query wihich gets the item details and inserts within the cursor, so it was querying for the same item which it inserted again and hence was in loop and ran for more than an hour for 100 odd records, we changed it to have INSENSITIVE SCROLL CURSOR FOR and it worked fine.
please share your valuable suggestions on what is the purpose of this statement. i will be very thankful.
Thanks for your reply. we used INSENSITIVE SCROLL CURSOR FOR clause and i think by default it is STATIC only. It worked fine after giving this clause with the cursor declaration.