Subject Re: Dynamic Query in Firebird
Author Milan Babuskov
--- Tomy Handaka wrote:
> How to create a stored procedure that receive sql query
> as input parameter and return values based on its input?
> The skeleton for the stored procedure is:
> create procedure spDynamicQuery(sqlQuery varchar(1024))
> as
> begin
> -- execute statement :sqlQuery here
> end

Instead of using stored procedure perhaps EXECUTE BLOCK is the right
approach for you. Take a look at release notes of Firebird 2 for more

Milan Babuskov