On 11-7-2014 17:31, Sergio Garcia [email protected] [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
