Sushant Bagul

Sushant Bagul

  • 2.2k
  • 16
  • 2.5k

OracleBulkCopy WriteToServer method not working for large records.

Nov 30 2021 1:41 PM

We have recently migrated Oracle 12c to Oracle 19c, where for ODP.Net we have used DDTek.Oracle but for migrated code we are using Oracle.DataAccess dll.

We have requirement to load file data into database, to achieve this we have implemeted .Net code by using Oracle.DataAccess.Client BulkCopy, WriteToServer() functionality where we have Oracle19c as database, we have one file of 26+Lakh records which is throwing error as "Attempted to read or write protected memory. this is often an indication that memory is corrupt".

The same code is working fine for Oracle 12c with DDTek.Oracle dll for 26+ lakh records, but not in migrated oracle version.

Your help is highly appreciated.

Answers (1)