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

Using Transactional Triggers as Block DataSources

Transactional triggers may be used to provide data for data blocks. Transactional triggers are typically used when Oracle Forms is running against a non-ORACLE datasource. When transactional triggers are used, Oracle Forms default functionality is replaced.

A transactional trigger block datasource can be used for both query and DML. Array processing is not supported when the block datasource is based on a transactional trigger.


Query Data Source Type property

About writing trigger code

About writing SQL statements in triggers

Transactional triggers

Guidelines for choosing block datasources

Using tables as block datasources

Using stored procedures as block datasources

Using the FROM clause as a block datasource

About array processing