Subject Re: [firebird-support] Transactional Commands in Stored procedures.
Author Ann Harrison
Mahesh Ishwar wrote:

>Hello All,
>I was goin' thru the following link
>& 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 for not allowing Begin Transaction, End transaction, commit, etc.
>Can anyone tell me why this is so..?
Because transactions belong to the client application and should not be
changed by stored procedures. If the procedure commited work that your
application later wanted to rollback, you'd have a mess. However,
procedures do have a reasonably complete error handling mechanism can
undo the work done within the procedure - or even part of it.