Fires once during the Post and Commit Transactions process, after the database commit occurs. Note that the Post-Forms-Commit trigger fires after inserts, updates, and deletes have been posted to the database, but before the transaction has been finalized by issuing the Commit. The Post-Database-Commit Trigger fires after Oracle Forms issues the Commit to finalize the transaction.
Definition Level form
SELECT statements, DML statements (DELETE, INSERT, UPDATE), unrestricted Built-ins
Enter Query Mode no
Use a Post-Database-Commit trigger to perform an action anytime a database commit has occurred.
There is no rollback, because at the point at which this trigger might fail, Oracle Forms has already moved past the point at which a successful rollback operation can be initiated as part of a failure response.
Post and Commit Transactions
/*
** FUNCTION recs_posted_and_not_committed
** RETURN BOOLEAN IS
** BEGIN
** Default_Value('TRUE','Global.Did_DB_Commit');
** RETURN (:System.Form_Status = 'QUERY'
** AND :Global.Did_DB_Commit = 'FALSE');
** END;
*/
BEGIN
:Global.Did_DB_Commit := 'FALSE';
END;