DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2001


    Hi all,

    I have a developer using SQL Server's dynamic cursor which means after he opens the cursor, he can get committed changes made by anyone and uncommitted changes made by the him when he fetches the data the next time. i.e. after the cursor gets opened, the result set will be updated dynamically until the cursor get closed.

    He wants me to find a counterpart in Oracle while I don't think there is an exact match. As far as I know, Oracle always maintain at least statement level read consistency, so once the cursor being opened, the result set will be static unless you open the cursor again. Is that right?

    If that's correct, how can he compare the differenece between the result set when the cursor is opened and closed?

    Thanks in advance for your reply...

  2. #2
    Join Date
    Aug 2001
    When a cursor is opened it will read data, consistent at that point of time.So you would be updataing only those data.U can see the changes made by another user on the same set of data only after re-executing the cursor. when the cursor is closed the cursor will not have any result sets to compare.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.