Submitted by: @dyemanov

Duplicates CORE2040

Example:

when any do
begin
insert into error_log(error_code, error_message) values (EXCEPTION_NUMBER, EXCEPTION_MESSAGE);
exception;
end

For user exceptions EXCEPTION_NUMBER = RDB$EXCEPTION_NUMBER
For system (internal) exceptions EXCEPTION_NUMBER = 0, but EXCEPTION_MESSAGE must contain system message text (for example, EXCEPTION_MESSAGE = 'Division by zero', EXCEPTION_NUMBER = 0, SQLCODE = -802)

Will be helpful to have an ability to alter exception_number from CREATE and ALTER EXCEPTION commands.

====== Test Details ======

See functional\exception\handling_name_and_message.fbt