<div>
An easy way to find out the firing sequence by yr &nbsp;own is write a text message like '...........trigger fire' in each of the trigger and then run the form. it will shows the messages at appropriate actions and so you can find the seq. order.<br />
<br />

</div>


An easy way to find out the firing sequence by yr  own is write a text message like '...........trigger fire' in each of the trigger and then run the form. it will shows the messages at appropriate actions and so you can find the seq. order.



<div>
hi<br />
<br />
the method given by leoahmad is also one way. the other way is go to program-&gt; tools-&gt;preferences-&gt;runtim<wbr />e-&gt; check the dubug messages. when u press every key u can find out which trigger is firing first.<br />
<br />
in case i have mentioned the option incorrectly, do bare with me since i dont have forms in my PC now. <br />
<br />
regards<br />
annamalai
</div>


hi

the method given by leoahmad is also one way. the other way is go to program-> tools->preferences->runtime-> check the dubug messages. when u press every key u can find out which trigger is firing first.

in case i have mentioned the option incorrectly, do bare with me since i dont have forms in my PC now.

regards
annamalai

<div>
<div class="content wysiwyg-content">
I have a form with a block named Employee whose base table is EMP.<br />
I have defined pre-insert, post-insert, pre-delete, post-delete, pre-update, post-update triggers at form level<br />
now i insert some rows , update some rows and then delete some rows and then hit the save button to save the information to the database. In which sequence does the above mentioned trigggers fire?<br />

</div>
</div>


I have a form with a block named Employee whose base table is EMP.
I have defined pre-insert, post-insert, pre-delete, post-delete, pre-update, post-update triggers at form level
now i insert some rows , update some rows and then delete some rows and then hit the save button to save the information to the database. In which sequence does the above mentioned trigggers fire?


trigger firing sequence

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.