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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Locking Multiple records

Re: Locking Multiple records

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 11 Nov 2003 20:05:36 +0100
Message-ID: <3nc2rvgcqmj5najiek0an0ruehpo3id1vt@4ax.com>


On 11 Nov 2003 02:29:17 -0800, runa_b_at_indiatimes.com (Runa) wrote:

>Is there anyway in which I can lock multiple records together, but
>release the lock one at a time i.e commit changes to one record at a
>time?
>
>Thanks.
>Runa

No there isn't, as this would violate the basic concept of a transaction.

--
Sybrand Bakker, Senior Oracle DBA
Received on Tue Nov 11 2003 - 13:05:36 CST

Original text of this message

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