Home » Developer & Programmer » Forms » Triggers firing at a time
Triggers firing at a time [message #208311] Sat, 09 December 2006 05:58 Go to next message
gauri.w
Messages: 2
Registered: December 2006
Junior Member
Hi,
I have a trigger on a column of a table which in turn calls a procedure. There is a column called account no, taking that into consideration we are uodating another table thru that proc.
Problem i am facing is whenever the trigger is firing at a time for more than one row in the table for same account...the proc is not upadting for three times. It is updating only once...
Pls suggest some solution.
Re: Triggers firing at a time [message #208467 is a reply to message #208311] Mon, 11 December 2006 00:20 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please post the header of the trigger, you probably don't have ' FOR EACH ROW' defined.

David
Re: Triggers firing at a time [message #208518 is a reply to message #208467] Mon, 11 December 2006 03:11 Go to previous message
arunsenthild
Messages: 17
Registered: October 2006
Location: Bangalore
Junior Member

hi
write the code in the PRE-INSERT trigger.
u'll get what u want.

Cheers,
Arun.
Previous Topic: how can i use date-picker.
Next Topic: using UTL_FILE with oracle forms
Goto Forum:
  


Current Time: Sun Dec 04 06:32:03 CST 2016

Total time taken to generate the page: 0.09980 seconds