Interested to Buy Any Domain ? << Click Here >> for more details...
what are difference between post database commit and
post-form commit?
- 2 Answers
- 18726 Views
- I also Faced
- E-Mail Answers
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 the "LOV of Validation" Property of an item? What is the use of it?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
Can a formula column be obtained through a select statement?
What are the unrestricted procedures used to change the popup screen position during run time ?
can i use lexical variable in formula column
Is it possible to disable the parameter from while running the report?
Is the After report trigger fired if the report execution fails?
What are the built-ins used for Getting cell values?
Can you change the alert messages at run-time?
What is an User_exit?
What is a visual attribute?
how to create the triggers in the forms?
Oracle General 
