Consultor Eletrônico



Kbase P9426: Session trigger in external .p procedure does not fire?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   31/12/2004
Status: Unverified

SYMPTOM(s):

Session trigger in external .p procedure does not fire?

CAUSE:

Transaction started in the calling procedure. Actual commit happens at the end of the transaction. By that time the external procedure containing the session procedure has already finished executing.

FIX:

To ensure that the session trigger in the external .p fires when you are already in a transaction enclose the call to the external procedure in its own sub transaction as per the following code:

DO TRANSACTION:
Run ExternalProcedureName.p.
END.