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

Transactional Triggers

Transactional triggers fire in response to a wide variety of events that occur as a form interacts with the data source.

Trigger

Typical Usage

On-Delete

Replace the default Oracle Forms processing for handling deleted records during transaction posting.

On-Insert

Replace the default Oracle Forms processing for handling inserted records during transaction posting.

On-Lock

Replace the default Oracle Forms processing for locking rows in the database.

On-Logon

Replace the default Oracle Forms processing for connecting to ORACLE, especially for a form that does not require a database connection or for connecting to a non-ORACLE data source.

On-Logout

Replace the default Oracle Forms processing for logout from ORACLE.

On-Update

Replace the default Oracle Forms processing for handling updated records during transaction posting.

Post-Database-Commit

Augment default Oracle Forms processing following a database commit.

Post-Delete

Audit transactions following the deletion of a row from the database.

Post-Forms-Commit

Augment the default Oracle Forms commit statement prior to committing a transaction.

Post-Insert

Audit transactions following the insertion of a row in the database.

Post-Update

Audit transactions following the updating of a row in the database.

Pre-Commit

Perform an action immediately before the Post and Commit Transactions process, when Oracle Forms determines that there are changes in the form to post or to commit.

Pre-Delete

Manipulate a record prior to its being deleted from the database during the default Post and Commit Transactions process; for example, to prevent deletion of the record if certain conditions exist.

Pre-Insert

Manipulate a record prior to its being inserted in the database during the default Post and Commit Transactions process.

Pre-Update

Validate or modify a record prior to its being updated in the database during the default Post and Commit Transactions process.

Note: This is only a partial List of the transactional triggers available. Many of the triggers not shown here are On-event triggers that exist primarily for applications that will run against a non-ORACLE data source.


Creating a trigger in the Object Navigator

Block processing triggers

Interface event triggers

Master/Detail triggers

Message-handling triggers

Navigational triggers

Query-time triggers

Validation triggers

Other trigger categories