Subject Is FB supports the dynamic SQL in stored procedure?
Author Dara Durum
Hi!

I want to ask that is fb supports dynamic usage of SQL, or variable as
SQL (or part of SQL) statement in stored procedures?

:tablename = call CreateTempTable;
insert into :tablename ....
drop table :tablename

or (FireBird like cursor handling):

sql = "select * from " || :tablename || " where..."
for select :sql ....
...

Thanks for your help:
dd