Interested to Buy Any Domain ? << Click Here >> for more details...
what are difference between post database commit and
post-form commit?
- 2 Answers
- 18674 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 a Layout Editor?
What is a predefined exception available in forms 4.0?
When is PRE-QUERY trigger executed ?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
What is the maximum size of a form ?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
How many number of columns a record group can have?
What are modal windows?
What is the use of hidden column?
what are the different objects that you cannot copy or reference in object groups?
What are the default extensions of the files careated by forms modules?
There are Two pl/sql Libraries Lib1,Lib2 are attached to a form and these two libraries contains functions with same name fun1 (i,e lib1 have a function fun1 and lib2 also have a function fun1).how to call these functios from forms?
Oracle General 
