Re: PL/SQL: How release row lock w/o COMMIT?

Tobias Besch wrote:

> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in
> news:YRn2c.57644$ko6.406364_at_attbi_s02:
>
>

>>Investigate savepoint.  You might also use dbms_lock package,
>>but it would require that othes use it.

Create a savepoint
Lock the row
Rollback to savepoint

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