Difference between post database commit and post-form commit?

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

Post-Database-Commit :

- It fires once during the Post and Commit Transactions process, after the database commit occurs.

- It fires after Oracle Forms issue the Commit to finalize the transaction.

The Post-Forms-Commit :

- It fires once during the Post and Commit Transactions process.

- If there are records in the form that have been marked as inserts, updates, or deletes, this trigger fires after these changes have been written to the database but before Oracle Forms issues the database Commit to finalize the transaction.

- If the operator or the application initiates a Commit when there are no records in the form have been marked as inserts, updates, or deletes,then Oracle Forms fires these, without posting changes to the database
What is Exception in Oracle?
Errors occur during runtime processing due to either hardware or network failure or application logic errors are known as exception.....
What are the predefined oracle exceptions?
Following is the predefined oracle exceptions No_data_found Too_many_rows Zero_divide.....
Explain user defined exceptions in oracle
A user can explicitly raise an exception by using the Raise command.....
Post your comment