Mahesh,

MI> & can't to know that there can't be any DDL statements and transactional commands in stored procedures & triggers. I understand why DDL statements are not allowed, but couldn''t get the reasons
MI> for not allowing Begin Transaction, End transaction, commit, etc.
MI> Can anyone tell me why this is so..?

I'd say that, given Firebird's ability to automatically roll back
the work done by a failed statement (including also stored procedures),
transaction control in triggers and stored procedure is neither useful
nor desirable. What do you need it for?
Ciao
--
Nando mailto:nandod@...