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 user exit.?
2 Answers IBM, Synergy, Zensar,
Why is a Where clause faster than a group filter or a format trigger?
List the editors availables in forms 4.0?
can i use lexical variable in formula column
Use the Add_group_row procedure to add a row to a static record group 1. true or false?
Can you truncate a table in a procedure in Oracle Forms?
What are the different types of Coordinations of the Master with the Detail block?
how to pass 2 variables from one form to other form
Can a field be used in a report wihtout it appearing in any data group?
Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;
What is 4-way match?
What are the default parameter that appear at run time in the parameter screen?