--- 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
info.

--
Milan Babuskov
http://www.guacosoft.com