Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Which trigger has to choose - oracle forms

User_R4VJDJun 28 2021

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.

Comments

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

1 - 1

Post Details

Added on Jun 28 2021
#forms, #moved-from-devops, #oracle-developer-communities, #plsql
1 comment
29 views