what are difference between post database commit and
post-form commit?
- 2 Answers
- 17588 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 |
Do user parameters appear in the data modal editor in 2.5?
Which of the above methods is the faster method?
What is a predefined exception available in forms 4.0?
What is a Package Procedure ?
What are different types of modules available in oracle form?
What is difference between open_form and call_form?
What are the design facilities available in forms 4.0?
How to create placeholder columns?
HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.
why the Ctl file u put only in bin folder why not in other folder
What is the significance of PAGE 0 in forms 3.0 ?
Can you mention lexical parameter in select statement in the data model?
Oracle General 
