Creating a Data Block from a Transactional Trigger
To create a data block from a transactional trigger:
- Choose Tools | Data Block Wizard to invoke a
wizard that guides you through the process of building a data block.
Or,
- In the Object Navigator, click the Data Blocks
node.
- Click Create in the toolbar.
- In the New Data Block dialog, choose Build a New Data
Block Manually and click OK.
- Double-click the Block object icon to display the Property Palette.
- Under the Database node, set the Query Data
Source Type property to Transactional Triggers.
- Define the appropriate transactional triggers.
- Under the Advanced Database node, set the DML
Data Target Type property to Transactional Triggers.
- Define the appropriate transactional triggers.
- 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.
Related topics
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