| unlocking rows [message #80537] |
Wed, 09 October 2002 06:20  |
bheki
Messages: 1
Registered: October 2002
|
Junior Member |
|
|
how do I check which user is locking the record and
how do I unlock the record and make it available to
other users. In a ORACLE WEB DEV set up with 500
users. Please help!!!!!!!!!!!!
|
|
|
|
| Re: unlocking rows [message #80544 is a reply to message #80537] |
Wed, 09 October 2002 22:08  |
Shiju
Messages: 12
Registered: October 2002
|
Junior Member |
|
|
Check whether the row is locked using NOWAIT.
If the row is locked, it gives Resource busy
ORA-00054 Exception
Eg.
declare
b number;
begin
select a into b from a where a='999' for update of a nowait;
end;
exception when others then
if sqlcode=-0054 then
<Your Lock Message>
end if;
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
