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 is a library in Forms 4.0?
EXIT_FORM is a restricted package procedure ?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
Explain how can you use the same lov for 2 columns?
What do we mean by record group in oracle forms?
Suppose I want to fire block level sequence before form level, then is it possible?
Can a sigle canvas be used by different blocks ?
List system variables available in forms 4.0, and not available in forms ?
what are the oracle forms services components include?
What are the two phases of block coordination?
What is the use of image_zoom built-in?
Can you attach an lov to a field at run-time? if yes, give the build-in name.