On 03/02/2020 13:16, Leyne, Sean wrote: > > > > 3. Order of exception and update should be reverted, sussped removed, > also maybe this update should be run in autonomous transaction but > this is not nescessary as someone can commit after this error. > > > > <SL> AFAIK, an Exception “kills/terminates” the current operation and > any changes done are undone – regardless of commit. > > > > When it has SUSPEND, it rollback only things from the later savepoint created at SUSPEND.
But this procedure has no output parameters and could not be called with SELECT. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
