Subject | Re: [firebird-support] Why IN AUTONOMOUS TRANSACTION doesnt work here? |
---|---|
Author | W O |
Post date | 2013-09-20T19:06:47Z |
Yes Ivan, you are right, but I would like some way of recording those errors in a table, for later watch them.
Greetings.
Walter.
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 normalprogram flow is interrupted ? You caused error *before* the procedure was invokedso 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 valuewould you expect in NEW. variable ?Ivan