Re: [GENERAL] Ending transaction inside stored function

2004-01-22 Thread Chris Travers
> 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

[GENERAL] Ending transaction inside stored function

2004-01-21 Thread lnd
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