what are difference between post database commit and
post-form commit?
Answers were Sorted based on User's Feedback
Answer / chaudhry
Post-form commit fires once during the post and
commit transactions process, after the database commit
occures. The post-form-commit trigger fires after
inserts,updates and deletes have been posted to the
database but before the transactions have been
finalished in the issuing the command.The
post-database-commit trigger fires after oracle forms
issues the commit to finalished transactions.
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / sudipta santra
Both the trigger will fire after the commit occur in the
forms, but the difference makes that : Post-Form-Commit
fires in between the post to the database and committed the
transaction whereas, the Post-Database-Commit fires after
the committed transaction in database.
Note: If the two triggers are written or applied, then Post-
Form-Commit will fire first then Post-Database-Commit will
fire.
| Is This Answer Correct ? | 3 Yes | 1 No |
What is bind reference and how can it carate?
What are the default extension of the files created by library module?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
what is the sequence of firing triggers in forms?
When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
.fmb will be in which folder
Explain how can you use the same lov for 2 columns?
what is procedure like symbols of bind and lexical
how do u place it in required folder
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
What are the different window events activated at runtimes?