Mahesh Ishwar wrote:

>Hello All,
>I was goin' thru the following link
>http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID='323'
>
>& 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.

Regards,


Ann