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

On-Insert Trigger

Description

Fires during the Post and Commit Transactions process when a record is inserted. Specifically, it fires after the Pre-Insert trigger fires and before the Post-Insert trigger fires, when Oracle Forms would normally insert a record in the database. It fires once for each row that is marked for insertion into the database.

Definition Level form or block

Legal Commands

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

Enter Query Mode no

Usage Notes

On Failure

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

  • sets the error location
  • rolls back to the most recent savepoint
  • Fires In

    Post and Commit Transactions


    INSERT_RECORD Built-in