Hi,

I am looking for a way to run certain codes multiple times (like a
function call, without resorting to UDF) within a stored procedure, so
that the same codes will not be repeated within a stored procedure.

Thanks.

--- In firebird-support@yahoogroups.com, "Sasha Matijasic"
<selectnull@...> wrote:

>
> >
> > Can I use 'Execute Block Statement" in a stored procedure?
> > If not so, how can we make use of this new feature?
> >
>
> From release notes:
> "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
>