Locking referential table

[Samuel]

I am using ODAC 5.5 for Delphi 7. Here I have two table A and B where A has a referential key to B. While I start a transaction and try to edit a record in table A, it is OK that it acquires a row exclusive lock on table A. But I found that it also get a lock on table B. How to avoid locking the referential table? thanks.

[Plash]

We cannot reproduce the problem. Please specify full version of ODAC including build number (see Odac\About ODAC in Delphi menu). If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

[HDumas]

Hi...

We have been working on this exact same problem for a while now... It is very difficult to reproduce. When this happens, our DBA looks into Oracle to see where it locks and what kind of a lock and which user is blocking all the other users... and the blocking in Oracle defies all logic... It shows a lock on the row, but for some reason, it seems to lock the whole table.

We are also using Delphi 7 with ODAC 5.50.0.15 with OraTools AddIn 2.60.2.17.

Would you know more about this problem??

H. Dumas