| Step Details |
| Introduced in Version | 8.20.0 |
| Last Modified in Version | 8.20.0 |
| Location | Database > Oracle |
This Step performs a batch insert (writing multiple entities at once) to an Oracle Database, with a delay before execution. This Step also schedules the write as a Thread Job.
Prerequisites
Properties
Database Information
| Property | Description | DataType |
|---|
| Table Name | This property is the table name associated with the Database Table Definition ID. | -- |
| Connection Name | This property is the name of the Database Connection. | -- |
Environment
| Property | Description | DataType |
|---|
| Use Transactional Data | When this property is checked, a Transaction field appears under Inputs, enabling Users to utilize Transaction Data within the Flow. | TransactionData |
| Run In Defined Environment | This property is checked by default and enables Users to run the Flow within a defined environment. | -- |
| Override Connection String | When this property is checked, a Connection String field appears under Inputs, enabling Users to manually enter a Connection String for a desired Database. | String |
Settings
| Property | Description | Datatype |
|---|
| Delay Write to Database | This setting enables Users to customize the Delay Write to the Database and is pre-selected by default. | -- |
| Insert Batch Size | This setting enables Users to customize the Insert Batch Size and is pre-selected by default. | -- |
| Database Table Definition ID | This setting enables Users to enter a Database Table Definition ID from a desired Database Table Integration. | -- |
Outputs
| Property | Description | Data Type |
|---|
| Error Details | Outputs a string of Error Details. | String |
| Error Message | Outputs a string with an Error Message. | String |
.png)
Step Changes
| Description | Version | Release Date | Developer Task |
|---|
| The Batch Insert to Oracle with Delay Step was added as a new Flow Step to the Product. | 8.20 | June 2024 | [DT-041171] |