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

Home -> Community -> Usenet -> c.d.o.tools -> Locking

Locking

From: Graham Atkinson <g.a_at_totalise.co.uk>
Date: Thu, 16 Nov 2000 17:42:01 -0000
Message-ID: <974396521.621843@ernani.logica.co.uk> 






Is it possible within Oracle to lock a single record on a table so that any
application attempting to update that record would get an error retruned.
This lock needs to be present even if the database has been shutdown and
restarted (although I could use a DBMS_JOB to kick the lock off again)



Thanks,



Graham.
Received on Thu Nov 16 2000 - 11:42:01 CST












Original text of this message













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