Helen

My example shows that when an user exception is raised, sqlcode = -999. Documentation says

5. If user-defined exception is thrown, both SQLCODE and GDSCODE variables contain zero

so, IMHO there is a bug, in the implementation, or in the doc.

Also, execution of two WHEN clauses seems not clear to me (I think is a bug), if program control flows in a WHEN, must not reach another WHEN. Like in a CASE.

If sounds reasonable to you asking firebird-architect about a context variable that returns something for a user-defined exception;
that ecourages me to do the post!

Thanks
Adrian