A script-enabled browser is required for this page to function properly.

On-Commit Trigger

Description

Fires whenever Oracle Forms would normally issue a database commit statement to finalize a transaction. By default, this operation occurs after all records that have been marked as updates, inserts, and deletes have been posted to the database.

The default COMMIT statement that Oracle Forms issues to finalize a transaction during the Post and Commit Transactions process.

Definition Level form

Legal Commands

SELECT statements, PL/SQL, unrestricted Built-ins

Enter Query Mode no

Usage Notes

On Failure

Aborts Post and Commit processing

Fires In

Post and Commit Transactions

On-Commit Trigger Example

This example disables the commit operation when running against a datasource that does not support transaction control. If the application is running against ORACLE, the commit operation behaves normally.

BEGIN
IF Get_Application_Property(DATA_SOURCE) = 'ORACLE' THEN
Commit_Form;
ELSIF form_fatal OR form_failure THEN
raise form_trigger_failure;
END IF;

/*
** Otherwise, no action is performed
*/
END;  

COMMIT_FORM Built-in