Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle triggers not always firing
Hello,
My advise to you is to check for mutating or constraining tables .
Regards,
Regards,
"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.
>
> 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
> --
>
>
Received on Sat Jun 21 2003 - 01:30:27 CDT