Re: Oracle triggers not always firing

Make sure your database objects are 'VALID'. We have this same problem where PowerBuilder has this annoyance where it will not recompile invalid database objects upon use. I don't recall what happens for triggers, but I remember for Functions, for example, PowerBuilder simple skips the inline SQL function call.

I wish I could give you a workaround, but other than recompiling invalid objects, I don't know of any. Sorry.

HTH Phil

"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 Fri Jun 20 2003 - 09:51:13 CDT