Subject | Re: [firebird-support] Execute statement |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-11-27T22:26:20Z |
Hi Martijn,
Thanks and greetings,
Paul Vinkenoog
>> I suppose however that "my" version should work too, becauseOK - that settles it, then :-)
>> 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...
Thanks and greetings,
Paul Vinkenoog