> Action: How is this done efficiently in Firebird?

There is thing called EXECUTE BLOCK, probably similar to the BEGIN ATOMIC,
but it is available in FB 2.0 (and probably in Vulcan). In Firebird 1.5 you
could use EXECUTE STATEMENT in a stored procedure, something like:

CREATE PROCEDURE EXEC_BLOCK(statement VARCHAR)
AS BEGIN
EXECUTE STATEMENT :statement;
END

I hope that it can execute multiple statements. If not, then the only idea
is to generate a stored procedure dynamically, execute it and then drop it.

but you have to check the size limitations, anyway there is a 64k limit for
an SQL statement.

Roman