Home » SQL & PL/SQL » SQL & PL/SQL » Trigger firing when it shouldn't
Trigger firing when it shouldn't [message #725] Thu, 28 February 2002 05:35 Go to next message
Lee
Messages: 56
Registered: May 1999
Member
We have a before trigger, "insert or update of col1, col2, col3 on table1 for each row", that is firing when we update col4, even though it is not in the update of clause. If we rebuild the trigger, it behaves correctly.

We accidently discovered the trigger was mis-behaving in production, so we exported the prod db and put it in a test env. The trigger still mis-behaved until we dropped and recreated it.

Anyone experienced this behavior?

The system is 8.1.7 on Win 2000

Thanks,
Lee
Re: Trigger firing when it shouldn't [message #726 is a reply to message #725] Thu, 28 February 2002 07:42 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
i tested it here in 8.1.7 and could not reproduce the problem.

can u write a small trigger and replicate the problem and send me the code. it may be a problem with ur code;
Previous Topic: Table Name as Parameter in Function
Next Topic: change sysdate
Goto Forum:
  


Current Time: Thu Mar 28 14:01:28 CDT 2024