Subject Re: [Firebird-Architect] Execute procedure using Role ?
Author Geoff Worboys
Adriano dos Santos Fernandes wrote:
> Geoff Worboys escreveu:
>> When you consider the flag
>> table maintenance has to go around BEGIN ... WHEN ANY ... END
>> blocks - it gets quite horrible to maintain and starts to make
>> even the most simple procedures quite ugly.
> There is no need to mess with WHEN, when exception happens it
> will be automatically rolled back to previous savepoint.

Tut, tut. You are making unwarranted assumptions.

As noted previously this is a modular system with procedures
calling procedures. To not catch exceptions and clean up after
yourself is to ignore the possibility that a caller may catch
and ignore certain exceptions - leaving behind the detritus.

--
Geoff Worboys
Telesis Computing