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

On-Update Trigger

Description

Fires during the Post and Commit Transactions process while updating a record. Specifically, it fires after the Pre-Update trigger fires and before the Post-Update trigger fires, when Oracle Forms would normally update a record in the database. It fires once for each row that is marked for update in the form.

Definition Level form or block

Legal Commands

SELECT statements, DML statements (DELETE, INSERT, UPDATE), unrestricted Built-ins

Enter Query Mode no

Usage Notes

Use an On-Update trigger to replace the default Oracle Forms processing for handling updated records during transaction posting.

To perform the default Oracle Forms processing from this trigger, include a call to the UPDATE_RECORD Built-in.

On Failure

Oracle Forms performs the following steps when the On-Update trigger fails:

Fires In

Post and Commit Transactions