Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Explicit Locking in PL/SQL
Hi,
I got a problem similar to the following.
Two tables -- master and detail. When a user edits a record in the master table, I want to lock (read-only allowed) the corresponding detail records. So in my edit_master_table stored procedure, I'd like to lock the detail table, do the edits, and then unlock the detail table.
What's the best way to do this? BTW, I'd like to trying locking with a wait before kicking other people out. Is this possible?
Thanks,
Salaam Yitbarek
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 11:11:09 CST