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

Pre-Delete Trigger

Description

Fires during the Post and Commit Transactions process, before a row is deleted. It fires once for each record that is marked for delete.

Note: Oracle Forms creates a Pre-Delete trigger automatically for any master-detail relation that has the Delete Record Behavior property set to Cascading

Definition Level form or block

Legal Commands

SELECT statements, Data Manipulation Language (DML) statements (i.e., DELETE, INSERT, UPDATE), unrestricted Built-ins

Enter Query Mode no

Usage Notes

Use a Pre-Delete trigger to delete the detail record of a master record.

Use a Pre-Delete trigger to prevent the deletion of a record if that record is the master record for detail records that still exist.

On Failure

Oracle Forms performs the following steps when the Pre-Delete trigger fails:

Fires In

Post and Commit Transactions