Well German, the right group for this kind of question is
ib-support@yahoogroups.com.

If you had asked this question there I would have told you that stored
procedures are stored in executable format, and that it is impossible to do
any dynamic thing like you desire within them.

Set

At 12:06 03.03.2003 +0000, you wrote:

>hello,
>
>I need to execute a string query into a stored procedure like:
>
>execute 'select * from tableName'
>
>or
>
>execute :varstring
>
>where varstring is an input parameter with a truly sql statement.
>
>does anybody know how to perform that ? I am using firebird.
>
>thanks,
>german