Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Detecting the user that has a lock on a particular row. ??
Can anyone help me figure out how to detect what oracle username has a "for update" lock on a particular lock on a row in a particular table?
In other Words, I would like to write a stored function that accepted a TABLE_NAME and PRIMARY KEY. The function would then return the Oracle USERNAME that has that row locked for update purposes. It would return a null, if no one has that particular row locked.
Thanks in advance for any help.
Rodney Received on Wed Feb 04 1998 - 00:00:00 CST