Re: Oracle triggers not always firing

From: Dag Arne Matre <dam_at_robin.no.antispam>
Date: Mon, 23 Jun 2003 12:19:41 +0200
Message-ID: <6vAJa.1577$os2.22116@news2.e.nsc.no>

"Lisa McGrath" <lmcgrath_at_uwsa.edu> wrote in message news:3EF3026A.A1B4BD5B_at_uwsa.edu...
>
> Jim,
>
> thanks for the reply. The transaction is committing. I can check the
table the
> next day and the updates are there, so the commit must work, but the
changes
> that should have been made by the trigger are not there.

If you change the primary key, the PowerBuilder datawindow by default will first issue a delete, then an insert. Turn on tracing in PB or Oracle it to see if UPDATE or DELETE/INSERT is done.

D A Received on Mon Jun 23 2003 - 05:19:41 CDT