> I am using Firebird 2.5
>
> My questions are:
>
> - When and why to use the instruction "execute block"?
> - What is the advantage over a Stored Procedure?
> - What can I do with an execute block and not with a store procedure?

- Execute block is a client-side thing, which allows you to run PSQL
code without creating a stored procedure first.
- A stored procedure gets compiled at creation time and stored in the
database. Execute block isn't stored in the database and compilation
happens each time the execute block is called.
- A stored procedure is "visible" to all connections. Execute block isn't.
- Only the owner of a stored procedure can alter it. Everybody can run
an execute block statement

Ah well, just some points out of my mind. ;-)



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!