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 ERASE package procedure does ?
What are the default extension of the files created by library module?
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?
Explain about stacked canvas views?
How can a button be used in a report to give a drill down facility?
What are the design facilities available in forms 4.0?
Which of the two views should objects according to possession?
Can you truncate a table in a procedure in Oracle Forms?
i created a parameter list in reports. how to restrict that parameter list with parameters
What are the different types of Package Procedure ?
What is the usage of the confine mode in Layout Editor ?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?