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.