Submitted by: Dejan Schild (schild)

Duplicates CORE1693

Any use of EXECUTE STATEMENT in ON CONNECT database trigger raise error! Try this one, then check context variable 'WASERROR', it should be 0, but always is 333.

create or alter trigger CONNECT_GENERAL_SETUP
active on connect position 0
as
declare variable V_DBID bigint;
begin
RDB$SET_CONTEXT('USER_SESSION', 'WASERROR', 0);
execute statement 'SELECT 100 FROM RDB$DATABASE' into :V_DBID;
when any do
begin
RDB$SET_CONTEXT('USER_SESSION', 'WASERROR', 333);
end
end