Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle triggers not always firing
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...Received on Thu Jun 19 2003 - 22:11:27 CDT
> 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
> --
>
>