Can cursor's result set being updated dynamically?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Can cursor's result set being updated dynamically?

  1. #1
    Join Date
    May 2001
    Posts
    285

    Question

    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
    Location
    chennai,bangalore
    Posts
    840
    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.

    Regards
    anandkl
    anandkl

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