Use to create and configure actions.
Actions are templates for Data Definition Language (DDL) commands. They are used by the Common Format Designer to generate the scripts that implement a data model into a data server or synchronize the differences between a data model described in Oracle Data Integrator and its implementation in the data server.
An action corresponds to a DDL operation (create table, drop reference, and so forth).
The Action Editor has the following tabs:
Lines: One tab per Action Line
Properties | Description |
---|---|
Name | Name of the action, as it appears in the user interface. |
Type | Type of operation performed by the action. |
Description | Detailed description of the action. |
Each action contains several Action Lines, corresponding to the commands required to perform the DDL operation (for example, dropping a table requires dropping all its constraints first). The Detail tab lists these action lines, which you can create, delete, and organize using the buttons beside the grid.
To edit an existing action, select the tab that corresponds to the action line. The action lines details are described in the Lines section.
You can add or delete an action line by clicking the corresponding icon in the Lines toolbar of the Action Editor. You can arrange the order of the action lines by using the arrows to move the range forward or backward.
Properties | Description |
---|---|
Name | Name of the action line. This name will be given to the procedure command generated. |
Ignore Errors | This option must be selected if you do not want the procedure to stop when this specific command returns an error. For example, dropping a nonexisting table should not block the whole process. |
Commit | Indicates if a commit should be issued at the end of the command. |
Log Level | Logging level of the command. At execution time, commands can be kept in the log based on their log level. |
Isolation Level | Transaction isolation level for the command.
The levels of isolation are:
|
Transaction | You can execute commands on several concurrent transactions (numbered from 0 to 9) or work off-transaction by selecting the option Autocommit. |
Action Text | Code of the command to execute. Click Expression Editor to open the Expression Editor and write the action text. |
"Using Substitution Methods in Actions" in the "Introduction to the Substitution API" chapter in Oracle Fusion Middleware Developing Knowledge Modules with Oracle Data Integrator