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

"Tobias Besch" <me_at_privacy.net> wrote in message news:Xns94A5882E9CD11tobiasbeschgmxde_at_ID-86573.user.dfncis.de...
| 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

PL/SQL User's Guide and Reference, 'Using Autonomous Transactions'

;-{ mcs Received on Sun Mar 07 2004 - 07:30:01 CST