Subject Re: [firebird-support] Dynamic Query in Firebird
Author Martijn Tonies
Hello Tomy,

> 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
> example of sqlQuery: 'select users.username from users where users.userid
= ''John'''
> I've tried many approaches but there's an error message (Wrong request

EXECUTE STATEMENT is how you do it.

But, if you do a SELECT, it needs something to return values to. You cannot
"just select" and expect the results to go "somewhere".

Show us your exact procedure.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!