> Is there any way to end (commit/rollback) a transaction inside a stored
> function?
Currently not, but you can RAISE EXCEPTION to terminate the containing
transaction. This will essentially rollback the transaction when it hits
the COMMIT statement (or implied version).
Best Wishes,
Chris Tra
This was probably asked n-times but still:
Is there any way to end (commit/rollback) a transaction inside a stored
function?
(The reason why it is good to commit/rollback in a stored procedure is that
in C/S environment it is not uncommon to have a dead client holding
locks(unfinished transactio