Re: Oracle triggers not always firing

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.

Lisa

Jim Kennedy wrote:

> Are you committing? The triggers always fire.
> Jim
>
> --
> Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> with family. Remove the negative part, keep the minus sign. You can figure
> it out.
> "Lisa McGrath" <lmcgrath_at_uwsa.edu> wrote in message
> news:3EF2360B.1A32E6EA_at_uwsa.edu...
> > I'm having problems with Oracle triggers firing when using Powerbuilder.
> >
> > I'm using Powerbuilder 7.03 and Oracle 8.1.7. I have 'before update
> > on each row' triggers coded for an Oracle table. If I go to the PB
> > database painter, isql tab, and code sql to update the table then the
> > triggers fire as expected.
> >
> > If I go to the database painter, click on the table in the 'objects'
> > view, then click the 'Data Manipulation (grid) button and update data
> > in the table the triggers do not fire, although the database table is
> > updated.
> >
> > Why would the triggers sometimes fire & sometimes not, even though the
> > data in the table was updated? Any help would be greatly appreciated.
> >
> > Lisa
> >
> > ps - also posted to Powerbuilder newsgroups.
> >
> > --
> > Lisa McGrath
> > Lmcgrath_at_uwsa.edu (608) 263-4535
> > Office of Information Services
> > University of Wisconsin System Administration
> > --
> >
> >

--
Lisa McGrath
Lmcgrath_at_uwsa.edu    (608) 263-4535
Office of Information Services
University of Wisconsin System Administration
--