Subject | Transactional Commands in Stored procedures. |
---|---|
Author | Mahesh Ishwar |
Post date | 2003-07-21T15:15:26Z |
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..?
Thanx in Advance.
Meghansh
---------------------------------
Yahoo! Plus - For a better Internet experience
[Non-text portions of this message have been removed]
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..?
Thanx in Advance.
Meghansh
---------------------------------
Yahoo! Plus - For a better Internet experience
[Non-text portions of this message have been removed]