On 11-7-2014 17:31, Sergio Garcia sergiogarciaruso@...
[firebird-support] wrote:

>
>
> Hi All.
>
> Can I create a procedure inside another procedure? Something like this:
>
> SET TERM ^;
>
> RECREATE PROCEDURE proc
> AS
> DECLARE VARIABLE tmp INTEGER;
>
> PROCEDURE insideproc
> AS
> BEGIN
> <.....>
> END;
>
> BEGIN
> <.....>
> END;
>
> SET TERM ;^

That is not possible in Firebird 2.5. Firebird 3.0 will add sub-routines
that allow exactly this.

See
http://www.firebirdsql.org/en/news/firebird-3-0-alpha-2-release-is-available-for-testing-38022/
for Firebird 3.0 Alpha 2 (although you might want to use a more recent
snapshot for testing).

You can find more details in the Firebird 3.0 Alpha 2 release notes
(section PSQL Sub-routines). However note that discussion of Firebird
3.0 is off limits on Firebird-support until final release. If you have
further questions regarding Firebird 3, please subscribe to the
firebird-devel mailinglist.

Mark
--
Mark Rotteveel