Hi Set

I just upgraded to FB 2.5.2.26540 and tried the EXECUTE BLOCK again but had the same issues:
Starting transaction...
Preparing statement: EXECUTE BLOCK returns (Mystatement varchar(10000)) AS
DECLARE VARIABLE S VARCHAR(256)
Error: *** IBPP::SQLException ***
Context: Statement::Prepare( EXECUTE BLOCK returns (Mystatement varchar(10000)) AS
DECLARE VARIABLE S VARCHAR(256) )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 2, column 31


Total execution time: 0.015s



So as per your advice I changed it to CREATE PROCEDURE and created an SP called MyProc then I used the command SELECT * FROM MyProc and I do get a string back (BTW I had to increase 4096 to 10000 else got an overflow)

Now I can execute the string if I copy and paste it, but is there any way to directly execute the string returned from the SELECT * FROM MyProc? 

Please advise

Thanks and regards

Bhavbhuti