OraFAQ Forum: Forms » Triggers firing at a time

Home » Developer & Programmer » Forms » Triggers firing at a time

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

Triggers firing at a time [message #208311]

Sat, 09 December 2006 05:58

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.

Report message to a moderator

Re: Triggers firing at a time [message #208467 is a reply to message #208311]

Mon, 11 December 2006 00:20

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please post the header of the trigger, you probably don't have ' FOR EACH ROW' defined.

David

Report message to a moderator

Re: Triggers firing at a time [message #208518 is a reply to message #208467]

Mon, 11 December 2006 03:11

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.

Report message to a moderator

Previous Topic:	how can i use date-picker.
Next Topic:	using UTL_FILE with oracle forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:40:42 CDT 2024