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

Block Processing Triggers

Block processing triggers fire in response to events related to record management in a block.

Trigger

Typical Usage

When-Create-Record

Perform an action whenever Oracle Forms attempts to create a new record in a block. For example, to set complex, calculated, or data-driven default values that must be specified at runtime, rather than design time.

When-Clear-Block

Perform an action whenever Oracle Forms flushes the current block; that is, removes all records from the block.

When-Database-Record

Perform an action whenever Oracle Forms changes a record's status to Insert or Update, thus indicating that the record should be processed by the next COMMIT_FORM operation

When-Remove-Record

Perform an action whenever a record is cleared or deleted. For example, to adjust a running total that is being calculated for all of the records displayed in a block.

 


Creating a trigger in the Object Navigator

Interface event triggers

Master/Detail triggers

Message-handling triggers

Navigational triggers

Query-time triggers

Transactional triggers

Validation triggers

Other trigger categories