Home » SQL & PL/SQL » SQL & PL/SQL » What stops a trigger fireing
What stops a trigger fireing [message #347983] Mon, 15 September 2008 04:36 Go to next message
sussudio
Messages: 30
Registered: March 2005
Location: London
Member
Hello Guys

Any help with the below greatly appreciated.

At present, the problem is that triggers being created in the application are supposed to fire when a case gets updated within the client. It triggers a record status change in table A to update to 'S'. It is then that the problem occurs. A trigger is then supposed to fire to further change the status from 'S' to 'P' however, this is where the record seems to be sticking. When the trigger fails, there is no mention within the Alert log. I have to then fire the trigger manually through Toad to enable the update to take place and then app to carry on as normal.

Any ideas?

Many thanks for any help you can give.

The Operating system is Linux and it is Oracle 9.2
Re: What stops a trigger fireing [message #347985 is a reply to message #347983] Mon, 15 September 2008 04:39 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Give an example. Show us the table, with records in it.
Show the trigger-code.

Your explanation is not really very clear..
Re: What stops a trigger fireing [message #347987 is a reply to message #347983] Mon, 15 September 2008 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Any ideas?

Remove WHEN OTHERS from your code.

Regards
Michel
Re: What stops a trigger fireing [message #347988 is a reply to message #347983] Mon, 15 September 2008 04:44 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
sussudio wrote on Mon, 15 September 2008 11:36
I have to then fire the trigger manually through Toad


How do you manually fire a trigger ?!
Re: What stops a trigger fireing [message #347991 is a reply to message #347983] Mon, 15 September 2008 04:56 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If a Trigger errors, you would not expect a record to be written to the database Alert.Log. It would raise an exception that the application would have to handle in some fashion.

The only user tool that commonly writes to the Alert.Log is Dbms_Job, when a job fails (as there is no user process to inform).

Are you getting your terminology confused?
Previous Topic: Error while opening cursor when using TRANSLATE
Next Topic: i need help converting sqlserver triggers to oracle
Goto Forum:
  


Current Time: Mon Dec 05 14:56:05 CST 2016

Total time taken to generate the page: 0.08759 seconds