Re: lock on row, so that select brings up no result
Hi Eric,
that was one of my first ideas and i found that in the manual too. But when i test it, a second user can do a select and gets a result anyway. This is how i tried:
user A
begin;
select * from tbl_kunde where kdnr=20 for update;
user B
select * from tbl_kunde where kdnr=20;
At this moment B gets a result although A didn't finish with commit.
I also tried several isolation levels, but didn't get the wanted result.
Any further ideas?
Jürgen
Subject
Views
Written By
Posted
5315
May 24, 2008 10:16AM
2420
May 24, 2008 01:37PM
Re: lock on row, so that select brings up no result
2650
May 26, 2008 07:21AM
2361
May 27, 2008 12:50AM
2420
May 27, 2008 01:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.