Kbase P96008: Can I execute a separate transaction in a trigger of the database ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/12/2004 |
|
Status: Unverified
GOAL:
Can I execute a separate transaction in a trigger of the database ?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
FIX:
There is no way to execute a separate transaction in a database trigger, the trigger execution takes place within the same transaction scope where the client initiated the transaction, they are executed when Progress releases the records involved in the transaction.
The only option a user have to perform a distinct transaction within the same session is to run some code in the AppServer.