Home » RDBMS Server » Server Administration » Triggers not working (solaris 9)
Triggers not working [message #340179] Mon, 11 August 2008 17:21 Go to next message
varunvir
Messages: 363
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.
Re: Triggers not working [message #340180 is a reply to message #340179] Mon, 11 August 2008 17:24 Go to previous messageGo to next message
BlackSwan
Messages: 25047
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 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
I did not get the answer at this URL.
Thanks,
Re: Triggers not working [message #340184 is a reply to message #340179] Mon, 11 August 2008 18:37 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
I apologize that the clue locker is now empty.
Re: Triggers not working [message #340191 is a reply to message #340179] Mon, 11 August 2008 19:05 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
I am sorry still I am not able to understand what you are trying to say.
Thanks
Re: Triggers not working [message #340209 is a reply to message #340191] Mon, 11 August 2008 23:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Triggers not working [message #340232 is a reply to message #340179] Tue, 12 August 2008 01:04 Go to previous messageGo to next message
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.
Re: Triggers not working [message #340264 is a reply to message #340179] Tue, 12 August 2008 02:14 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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?
Re: Triggers not working [message #340434 is a reply to message #340264] Tue, 12 August 2008 18:31 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
No Triggers are not disabled.
Thanks
Re: Triggers not working [message #340545 is a reply to message #340434] Wed, 13 August 2008 04:36 Go to previous message
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
Previous Topic: touch count problem (plz.....)
Next Topic: Force one TableSpace
Goto Forum:
  


Current Time: Wed Dec 07 14:39:49 CST 2016

Total time taken to generate the page: 0.09861 seconds