Hi,

> I didn't test this yet, but i think firebird should not allow you execute

ddl

> inside stored procedures, even using an "execute statement". Just like a

commit.

> Isn't that right?

Via EXECUTE STATEMENT, you CAN execute DDL.

COMMIT isn't allowed (returns an error).

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com