Forum Stats

  • 3,837,677 Users
  • 2,262,284 Discussions


Which trigger has to choose - oracle forms

User_R4VJD Member Posts: 31 Green Ribbon

I have 5 insert statement in my oracle forms.

Form name : order_entry.fmb

Version : oracle forms 11g

Question: I have to write update statement in trigger.

Before applying commit on updated statement, all 5 inserts has to be completed.

So under which trigger I have to write my update statement in oracle forms.


  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 7,297 Employee

    Where exactly you do the checking to see if everything is ready for committing may depend on exactly what you mean by "completed". Try running some tests using a PRE-COMMIT trigger.

    Another option that might be less noisy could be to create a KEY-COMMIT trigger if the application is such that the user has to acknowledge the saving process (e.g. click on Save).

    Michael Ferrante

    Senior Principal Product Manager


    Twitter: @OracleFormsPM