Subject Re: [firebird-support] Execute statement
Author Paul Vinkenoog
Hi Martijn,

>> I suppose however that "my" version should work too, because
>> it's a valid statement.

> I wonder, though, if a local variable (my_numf) can be addressed
> from within the code that executes "EXECUTE STATEMENT".
>
> Well, just tried it:
> SET TERM ^^ ;
> CREATE PROCEDURE P_TEST returns (
> MYVAR Integer)
> AS
> begin
> execute statement 'select count(*) from rdb$database into :myvar';
> end
> ^^
> SET TERM ; ^^
>
> And it fails when executing...

OK - that settles it, then :-)

Thanks and greetings,
Paul Vinkenoog