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 |
How many types of trigger can be used in a table at a time ?
What are the types of calculated columns available?
What is a predefined exception available in forms 4.0?
Can you mention lexical parameter in select statement in the data model?
What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?
How can a square be drawn in the layout editor of the report writer?
What is the maximum no of chars the parameter can store?
did u received a single file or multiple files
List the buil-in routine for controlling window during run-time?
Can a field be used in a report wihtout it appearing in any data group?
.fmb will be in which folder
LOV can best describe a) window b)modal c)list d) none of these d)