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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 07 Mar 2004 10:03:54 -0800
Message-ID: <1078682599.558876@yasure>

Tobias Besch wrote:

> 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

You need to put a little effort into this. We are not going to do your work for you. Look them up:

http://www.psoug.org/reference/library.html

BTW: Save Points would work just fine your lack of willingness to research them not withstanding.

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

Received on Sun Mar 07 2004 - 12:03:54 CST