Kbase P61932: Trying to implement update triggers on a table for auditing
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/12/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Trying to implement update triggers on a table for auditing purposes
The update trigger issues an UPDATE SomeTable SET SomeField = SomeValue statement
[JDBC Progress Driver]: Too many recursions in call procedure. (7854)
CAUSE:
The definition of the update trigger is causing the trigger to be recursively invoked whenever any field in the table is modified. Because the trigger issues a second UPDATE against the table a recursion error is generated.
FIX:
Modify the trigger to explicitly list all fields in the table EXCEPT for the fields which hold the audit trail information. This will allow you to issue the UPDATE statement without triggering a recursion error.