Subject Re: [firebird-support] Dynamic SQL
Author Martijn Tonies

> 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