How to call a procedure after a commit

From: <mtayag_at_obviousmrp.com>
Date: Tue, 09 Mar 1999 17:40:49 GMT
Message-ID: <7c3mev$mvp$1@nnrp1.dejanews.com>

Hi there, I am using an Oracle 7.3 database (on an NT 4.0) with the Oracle Transparent Gateway R4.0.1.1.0 for DB2/400. We have written an RPG stored procedure on the AS/400 which we can call through a trigger on the NT side.

The RPG is being called from a trigger, but if the transaction happens to rollback, there is no way for me to sense this so that I can call the RPG procedure again, telling it to backout as well.

Is there any way for my trigger to know if the transaction that it is a part of has rolled back (or committed for that matter)? 2) Is there a way for me to call the trigger ONLY AFTER the transaction has committed?

Thanks for your help!

Michael Tayag
mtayag_at_obviousmrp.com
Software Developer
Obvious Professional Services

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 09 1999 - 11:40:49 CST