---
title: "Batch Insert to Oracle with Delay"
slug: "batch-insert-to-oracle-with-delay"
tags: ["oracle", "database", "Database Integration", "Database Tables"]
updated: 2025-02-06T16:11:42Z
published: 2025-02-06T16:11:42Z
canonical: "documentation.decisions.com/batch-insert-to-oracle-with-delay"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Batch Insert to Oracle with Delay

| 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](https://documentation.decisions.com/docs/about-thread-jobs).

### Prerequisites

- Users must [Integrate an External Oracle Database](https://documentation.decisions.com/docs/integrating-decisions-with-external-oracle-db) with the Decisions environment.
- After the External Database has been successfully connected, Users must use the following Documentation to [Integrate with a Database Table](https://documentation.decisions.com/v9/docs/integrate-with-database-table).

---

## 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 |

---

#### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-02-05_14h46_36(1).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](https://documentation.decisions.com/v99/docs/version-820x-release-notes?highlight=%5BDT-041171%5D%20Add%20flow%20steps%20in%20the%20product) | June 2024 | [DT-041171] |

---

Related Information

[Integrating Decisions with External Oracle Database](https://documentation.decisions.com/docs/integrating-decisions-with-external-oracle-db)

[Integrate with a Database Table](https://documentation.decisions.com/v9/docs/integrate-with-database-table)