[Firebird-devel] Exceptions with custom message text

[Marco M. <mm...@ly...>]

Hi, as far as I remember, exception with a message that can build "on 
the fly" in a trigger or a SP is available for FB 1.5 or planned.
Thinking about what I actually need in my database, I think that a 
"customisable" message would be better, I mean, something like:
EXP_WRONG_CODE = 'THE CODE %s IS WRONG, TRY AGAIN';
And in the SP
EXCEPTION EXP_WRONG_CODE(CAST(NEW.ITEMCODE AS VARCHAR(10)));
This is much better than having to assign all the message only to change 
a little but fundamental information.
What do you think about it?
Regards
Marco Menardi