> occurred. You would need to create a table (sqlcode, gdscode,
> text_of_message) in the database to look up the text of the message

during

> execution of your error handler.

Thanks Helen!

Do I understand correctly that this way I could handle only firebird
error messages and not the message my own exceptions raised like this:


exception inconsistent_data 'Period start is after period end';

or

exception inconsistent_data 'Period start is NULL';

I wish I could catch these in another procedure which is using this
procedure and add more info to the message:

when any do
begin
exception inconsistent_data 'Problems when processing item no. '
|| :item_no || ', error was: ' || ?????;
end

... something like SQLERRM in Oracle.

now, is this possible in 1.5? (but what about 2.0?)

Aivar