Re: Determining if a table/row is locked in a database

try to use this

begin
 lock table z in exclusive mode nowait;

except when others then

• table is locked another user end;

and this

cursoc c1 is select * from table where id=id# for update nowait begin

c1.open;
c1.close;

except when others then

• record is locked another user end;