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

"Tobias Besch" <me_at_privacy.net> wrote in message news:Xns94A587B71F028tobiasbeschgmxde_at_ID-86573.user.dfncis.de...
| Daniel Morgan <damorgan_at_x.washington.edu> wrote in
| news:1078602727.723486_at_yasure:
|
| > Create a savepoint
| > Lock the row
| > Rollback to savepoint
|
| But then would the UPDATE of the stored procedure be undone.
| So that's not useful.
|
| Tobias

just be careful about where you put your savepoint -- make sure it's after the update statement

also, realize that you can have multiple savepoints, and that oracle automatically sets a savepoint (unnamed) at the beginning of each procedure call -- any unhandled exception rolls back to the unnamed savepoint, so that the caller does not loose its changes (if it handles the exception)

;-{ mcs Received on Sun Mar 07 2004 - 07:03:29 CST