OraFAQ Forum: Forms » Trigger execution order

Home » Developer & Programmer » Forms » Trigger execution order (oracle 10g)

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

Trigger execution order [message #453794]

Sat, 01 May 2010 05:10

dhiraj_35
Messages: 4
Registered: February 2009

Junior Member

hi
every one

my question is ,

i have three trigger one at form level,second on database level
and third is on library level.

three are same .

which one will fire first,

give me answer.

Changed title to something meaningfull. Next time think about your title for a second rather than just putting oracle.

[Updated on: Sat, 01 May 2010 13:54] by Moderator

Report message to a moderator

Re: oracle [message #453799 is a reply to message #453794]

Sat, 01 May 2010 09:16

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

Senior Member
Account Moderator

Nice and useful title!

Regards
Michel

Report message to a moderator

Re: oracle [message #453811 is a reply to message #453794]

Sat, 01 May 2010 13:35

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

Senior Member
Account Moderator

Why do you expect all of them to fire?

As you already have those triggers, why don't you test it? (Why don't I answer? Because I don't know the answer. I should create test case and ... well, test it for you. But, as you can do it, I - obviously - don't have to. Happy testing! Don't forget to post the results.)

Report message to a moderator

Re: oracle [message #453814 is a reply to message #453794]

Sat, 01 May 2010 13:52

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

I'm not sure I can think of any forms triggers that work the same as database triggers so I'm not sure your question even makes sense.

Report message to a moderator

Re: Trigger execution order [message #453846 is a reply to message #453794]

Sun, 02 May 2010 06:18

Its_me_ved
Messages: 979
Registered: October 2009
Location: India

Senior Member

Probably you should need to understand why form level and database trigger is used and their functionalities.Please go through the docs or do a search you will get so many information.

Regards,
Ved

Report message to a moderator

Re: Trigger execution order [message #460897 is a reply to message #453794]

Tue, 15 June 2010 07:29

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Forms Trigger execution order
1-Form Level
2-Library Level
3-Database Level.

regards,
Irfan

Report message to a moderator

Re: Trigger execution order [message #460900 is a reply to message #460897]

Tue, 15 June 2010 07:35

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Really? care to explain why?

Report message to a moderator

Re: Trigger execution order [message #464262 is a reply to message #460900]

Wed, 07 July 2010 02:59

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

Senior Member
Account Moderator

I don't think that libraries have triggers.

David

Report message to a moderator

Previous Topic:	Sending Email with attached files
Next Topic:	open pdf file thru oracle forms developer 9i and extract blob from DB thru forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 23:48:32 CST 2025