Skip to Main Content
ProPricer Ideas Portal
Status Future consideration
Workspace Integration Pro
Created by Guest
Created on Apr 2, 2025

Add support for passing/setting the Oracle BulkCopyTimeout parameter value.

Description:

In Oracle, the bulk copy operation defaults to timing out after 30 seconds. However, the time out duration can be changed using the BulkCopyTimeout parameter of the OracleBulkCopy object. For example, you change the timeout duration to 600 seconds via the following code:

Oracle.ManagedDataAccess.Client.OracleBulkCopy. BulkCopyTimeout = 600

This parameter must be set via the object performing the copy operation (so via Integration Pro itself). The default can’t simply be changed in the database itself.

So my request is for you to add the ability to pass/set the BulkCopyTimeout parameter within Integration Pro.


Use Case/Example:

We have instances where Integration Pro often needs to bulk copy over 100K rows into an Oracle database. This can rarely be done in less than 30 seconds. By allowing us to set the BulkCopyTimeout parameter in Integration Pro, we can increase that duration to align with the expected load time/size.

  • Attach files