Hi,

> Is there a way to execute dynamic SQL from within a stored procedure? For

example, I've declared a VARCHAR and form the query in the stored in
procedure dependin' upon some logic vatrchar variable ,and then execute it.

>
> It is something like 'Execute Immediate' in oracle & 'Exec' in SQL Server.

Yes, in Firebird 1.5 - there is such a thing. Check the Firebird 1.5
release notes for details on 'EXECUTE STATEMENT'.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com