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