Subject Re: [firebird-support] Why IN AUTONOMOUS TRANSACTION doesnt work here?
Author W O
Yes Ivan, you are right, but I would like some way of recording those errors in a table, for later watch them.



On Fri, Sep 20, 2013 at 2:48 PM, Ivan Přenosil <Ivan.Prenosil@...> wrote:

> doesn't insert a row in the table ERRORS when I write:
> EXECUTE PROCEDURE SAVE_LASTNAME(0, 'SMITH678901234567890123456')
Isn’t it normal in all programming languages that when error occurs than normal
program flow is interrupted ? You caused error *before* the procedure was invoked
so it is expected that the body of procdure will not be entered.
Also, if e.g. the second parameter of the procedure was Integer, what value
would you expect in NEW. variable ?