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

Creating a Data Block from a Transactional Trigger

To create a data block from a transactional trigger:

  1. In the Object Navigator, click the Data Blocks node.
  2. Click Create in the toolbar.
  3. In the New Data Block dialog, choose Build a New Data Block Manually and click OK.
  4. Double-click the Block object icon to display the Property Palette.
  5. Under the Database node, set the Query Data Source Type property to Transactional Triggers.
  6. Define the appropriate transactional triggers.
  7. Under the Advanced Database node, set the DML Data Target Type property to Transactional Triggers.
  8. Define the appropriate transactional triggers.
  9. Under the General node, click the Name property, then type a name or accept the default name.  You can use any name that follows ORACLE naming conventions and is unique among blocks in the form. The block name is an internal descriptor that is not displayed at runtime.

Database Block property

DML Data Target Type property

DML Data Target Name property

Query Data Source Type property

Query Data Source Name property

Transactional triggers

About writing trigger code

About writing SQL statements in triggers

Using transactional triggers as block datasources