Database triggers are fired whenever any database action like INSERT, UPATE, DELETE, LOGON LOGOFF etc occurs. Form triggers on the other hand are fired in response to any event that takes place while working with the forms, say like navigating from one field to another or one block to another and so on.

Thanks
R.Rajan

Difference between database triggers and form triggers?

* Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen

* Can be row level or statement level No distinction between row level and statement level.

* Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms.

* Can be fired from any session executing the triggering DML statements. Can be fired only from the form that define the trigger.

* Can cause other database triggers to fire.Can cause other database triggers to fire, but not other form triggers.

Thanks

Sathian.K

Hi,

Can you please post some real time examples for Forms Trigger since i have no idea about Oracle Forms and reports.

__________________
Keep smiling...