Kbase P8238: Error 3242 when user defined session trigger runs external .p
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/31/2005 |
|
Status: Verified
SYMPTOM(s):
Overriding schema trigger within session (ON <event> OF <table> OVERRIDE)
Schema trigger in database has Check CRC flag switched ON.
Session trigger runs external procedure.
CRC for database trigger procedure <procedure> does not match schema. (3242)
CAUSE:
This is expected behavior.
Once the trigger is initiated, Progress assumes any external procedure being run is the schema trigger procedure.
Thus it will perform the CRC check if this is switched on in the database schema, and this check will fail because the external procedure called is different from the trigger procedure registered in the database.
FIX:
Either turn the schema trigger's CRC checking option OFF or do not call an external .p procedure from a user defined session trigger