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

> Is it possible in PL/SQL to lock a row and release the lock without
> doing a COMMIT?

A ROLLBACK will release the lock as well.  

Oracle will not release locks until a COMMIT or ROLLBACK for that transaction. Knowing that, have you considered making your stored proc an AUTONOMOUS TRANSACTION? That way, the transaction inside the stored proc is not tied to the transaction that called it.

HTH,
Brian Received on Sat Mar 06 2004 - 11:40:21 CST