OraFAQ Forum: Server Administration » Triggers not working

Home » RDBMS Server » Server Administration » Triggers not working (solaris 9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Triggers not working [message #340179]

Mon, 11 August 2008 17:21

varunvir
Messages: 389
Registered: November 2007

Senior Member

I have insert triggers on some tables.Previously everything was fine but now triggers are not getting fired on insert statement .I checked the status and all the triggers are valid.Can you give me suggestion what can i do to make the triggers work again.

Report message to a moderator

Re: Triggers not working [message #340180 is a reply to message #340179]

Mon, 11 August 2008 17:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

My car used to go.
Now my car does not go.
My car's gas tank is full.
Tell me how to make my car go again, please.

[Updated on: Mon, 11 August 2008 17:25] by Moderator

Report message to a moderator

Re: Triggers not working [message #340183 is a reply to message #340180]

Mon, 11 August 2008 18:12

varunvir
Messages: 389
Registered: November 2007

Senior Member

I did not get the answer at this URL.
Thanks,

Report message to a moderator

Re: Triggers not working [message #340184 is a reply to message #340179]

Mon, 11 August 2008 18:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I apologize that the clue locker is now empty.

Report message to a moderator

Re: Triggers not working [message #340191 is a reply to message #340179]

Mon, 11 August 2008 19:05

varunvir
Messages: 389
Registered: November 2007

Senior Member

I am sorry still I am not able to understand what you are trying to say.
Thanks

Report message to a moderator

Re: Triggers not working [message #340209 is a reply to message #340191]

Mon, 11 August 2008 23:35

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

To explain you what Ana said: we can answer your question if you can make his car works.
Or more explicitly, you don't give NO information to help you.

Regards
Michel

Report message to a moderator

Re: Triggers not working [message #340232 is a reply to message #340179]

Tue, 12 August 2008 01:04

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Quote:

Previously everything was fine but now triggers are not getting fired on insert statement

Data in the table does not always remains same. There may be change in the table data / conditions in the trigger are not matching as of the previous one.

Debug the trigger.

Report message to a moderator

Re: Triggers not working [message #340264 is a reply to message #340179]

Tue, 12 August 2008 02:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

varunvir

I checked the status and all the triggers are valid

They might be valid, but they also can be disabled. Are they disabled?

Report message to a moderator

Re: Triggers not working [message #340434 is a reply to message #340264]

Tue, 12 August 2008 18:31

varunvir
Messages: 389
Registered: November 2007

Senior Member

No Triggers are not disabled.
Thanks

Report message to a moderator

Re: Triggers not working [message #340545 is a reply to message #340434]

Wed, 13 August 2008 04:36

sumanthd
Messages: 10
Registered: June 2008
Location: Hyderabad

Junior Member

please verify what u have written in the trigger that is have u mentioned
create or replace <trigger name>
AFter or before INSERT ON <TABLE Name>

i hope u check it once.
if it is still not working what xactly are you trying to do. what is the code you are writing in the trigger.

check weather you are working on views if so use INSTEAD OF trigger

Smile

Report message to a moderator

Previous Topic:	touch count problem (plz.....)
Next Topic:	Force one TableSpace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 23:15:36 CST 2024