Subject | RE: [firebird-support] Execute Block statement |
---|---|
Author | Sasha Matijasic |
Post date | 2008-06-28T23:26:02Z |
>From release notes:
> Can I use 'Execute Block Statement" in a stored procedure?
> If not so, how can we make use of this new feature?
>
"The SQL language extension EXECUTE BLOCK makes "dynamic PSQL" available to SELECT specifications.
It has the effect of allowing a self-contained block of PSQL code to be executed in dynamic SQL as if it were a stored procedure."
So, if you are in a stored procedure already, why would you want to use execute block? What are you trying to do?
The way that I understand it, you use it from client side to "simulate" psql code.
Sasha