Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Detecting the user that has a lock on a particular row. ??

Detecting the user that has a lock on a particular row. ??

From: Rodney Barrett <rbarrett_at_solutionpt.com>
Date: 1998/02/04
Message-ID: <6badqo$h94@apple.telalink.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US