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

Master/Detail Triggers

Oracle Forms generates master/detail triggers automatically when a master/detail relation is defined between blocks. The default master/detail triggers enforce coordination between records in a detail block and the master record in a master block. Unless developing custom block-coordination schemes, you do not need to define these triggers. Instead, simply create a relation object, and let Oracle Forms generate the triggers required to manage coordination between the master and detail blocks in the relation.

Trigger

Typical Usage

On-Check-Delete-Master

Fires when Oracle Forms attempts to delete a record in a block that is a master block in a master/detail relation.

On-Clear-Details

Fires when Oracle Forms needs to clear records in a block that is a detail block in a master/detail relation because those records no longer correspond to the current record in the master block.

On-Populate-Details

Fires when Oracle Forms needs to fetch records into a block that is the detail block in a master/detail relation so that detail records are synchronized with the current record in the master block.


Creating a trigger in the Object Navigator

Block processing triggers

Interface event triggers

Message-handling triggers

Navigational triggers

Query-time triggers

Transactional triggers

Validation triggers

Other trigger categories