Great, thanks!!!

-bill
--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

> > 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