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
