Yves Goergen wrote:
> On 13.11.2007 14:01 CE(S)T, Baron Schwartz wrote:
>> It's more complicated than that. You can use them together, you just
>> have to do it like this:
>>
>> set autocommit = 0;
>> begin;
>> lock tables;
>> -- you are now in a transaction automatically begun by LOCK TABLES
>> .....
>
> I assume that at this point, any SELECT on the table I have locked
> should block. But guess what, it doesn't. So it doesn't really lock.
>
What kind of lock are you using?
-- cxn 1
set autocommit=0;
begin;
lock tables t1 write;
Query OK, 0 rows affected (6.29 sec)
-- cxn 2
set autocommit=0;
begin;
select * from t1;
-- hangs

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.