Re: Locking Multiple records

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
>
>

I'll second Sybrand's advice about doing it. But you can write your own locking in Oracle
using the DBMS_LOCK built-in package.

As I've said many times before ... just because you can ... doesn't mean you should.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)