View previous topic :: View next topic
|
Author |
Message |
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
Hi,
I have a cursor that is fetching some rows from a table and at the time of declaration I have given as for update of the same table from which I am fetching the values.
Now what process is like that I fetch a value from the table and perform some operation and then insert/update the values in that table, after the update/insert I do the commit.
So I would like to ask is that when I commit that table, will those updated value be there in the cursor .
Regards
Ketan Varhade |
|
Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
Ketan,
Once you use Fetch cursor and update the current row, it doesn't really matter for you if its updated in the cursor or not, as you will not be able to access that row again unless you re-open the cursor or use a select statement to read that row, which will definitely have the updated value as its committed. |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Whenever you issue a commit, all the open cursors will be closed, unless its a
|
|
Back to top |
|
|
|