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

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in news:404A0D05.355A0E24_at_remove_spam.peasland.com:

> A ROLLBACK will release the lock as well.

But I want to keep the changes the trored procedure made.

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

That sounds like a good solution.
How do I make proc1 an AUTONOMOUS TRANSACTION?

Tobias Received on Sun Mar 07 2004 - 06:24:22 CST