what are difference between post database commit and
post-form commit?

Answers were Sorted based on User's Feedback



what are difference between post database commit and post-form commit?..

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

what are difference between post database commit and post-form commit?..

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

Post New Answer

More Oracle Forms Reports Interview Questions

What is user exit.?

2 Answers   IBM, Synergy, Zensar,


Why is a Where clause faster than a group filter or a format trigger?

1 Answers  


List the editors availables in forms 4.0?

1 Answers  


can i use lexical variable in formula column

1 Answers  


Use the Add_group_row procedure to add a row to a static record group 1. true or false?

2 Answers  


Can you truncate a table in a procedure in Oracle Forms?

2 Answers  


What are the different types of Coordinations of the Master with the Detail block?

2 Answers  


how to pass 2 variables from one form to other form

1 Answers  


Can a field be used in a report wihtout it appearing in any data group?

1 Answers  


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;

2 Answers   TCS,


What is 4-way match?

2 Answers   Zensar,


What are the default parameter that appear at run time in the parameter screen?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)