Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Managed Driver 18.3, 19.3.0, 19.3.1, 19.9.0 Bulk Update problem

David2005Oct 23 2020 — edited Oct 26 2020

Hi all,
I am wrtting a peace of code to send data to the database using batch method. The code works fine when the operation is an insert, but in case of updating the command execution causes a WAIT SHORT TIME and never return.
In both test I am using the same set of data (near 65K registers) and commandtext are built manually.
In case of update seems that the registers are send one by one not as a full batch (but all the information is set into the command before to send to the database).
Are there any know problem related with update data in OracleCommand for this managed version?. Are there any workaround?

Comments
Post Details
Added on Oct 23 2020
25 comments
654 views