|
|
| Re: table changes and user activity [message #62432 is a reply to message #62430] |
Wed, 21 July 2004 14:20  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
Oracle has row-level locking by default, so handles multi-user updates just fine. To minimize record locking times, you need to design the transactions to get in, make the change and get out as soon as possible. The old Oracle forms method was to lock the record on the form as soon as you start updating it, but a better way these days is to read the record together with it's version counter or last update datetime field on your table and check that it's still the same when you want to update the record - else "record changed by another user".
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
