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
SELECT statements, DML statements (DELETE, INSERT, UPDATE), unrestricted Built-ins
Enter Query Mode no
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.
Oracle Forms performs the following steps when the On-Update trigger fails:
Post and Commit Transactions