Results 1 to 3 of 3

Thread: Cursors Processing

  1. #1
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Cursors Processing

    When I was inside a cursor loop I am updating records but not commiting records.

    Cursor ....
    LOOP

    Updating each record balance amount

    End Loop
    Commit;

    Some times I need to process each record balance two or three times. Does it cosider the balance amount before entering cursor loop or updated balance amount?


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Cursors Processing

    As you are commiting outside the loop it will consider the old value only.


  3. #3
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Cursors Processing

    Cusor takes values from the result set. Does a Cursor not Update the values in the result set? Which area does it use to store updated value? If it use the result set it should return updated values only.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact