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 SQL statements in triggers
Guidelines for choosing block datasources
Using tables as block datasources
Using stored procedures as block datasources