Kbase P96657: SQL-92: Is COMMIT statement supported in a Stored Procedure or Trigger?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/24/2004 |
|
Status: Unverified
GOAL:
Is COMMIT statement supported in a Stored Procedure or Trigger?
FACT(s) (Environment):
OpenEdge 10.x
Progress 9.x
FIX:
No, COMMIT statement is not supported when its used inside Stored Procedure or Trigger.
With the current implementation, no error will be returned neither while compiling nor executing Stored Procedure / Trigger containing COMMIT statement. The COMMIT statement will be just ignored by SQL-92 Engine.