Forum Stats

  • 3,750,516 Users
  • 2,250,187 Discussions
  • 7,866,997 Comments

Discussions

Which trigger has to choose - oracle forms

User_R4VJD
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.

Answers

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,803 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).