BUG: Inserted LONGRAW Data Truncated with MSDAORA Provider Using AppendChunk

ID: Q236790

The information in this article applies to:

Microsoft OLE DB Provider for Oracle, versions 2.0, 2.1

SYMPTOMS

When Using ActiveX Data Objects (ADO) and AppendChunk, Microsoft OLE DB Provider for Oracle truncates data that is being inserted into LONGRAW and LONG datatypes. Approximately 40K inserts into a LONGRAW field, while about 64K inserts into a LONG field.

RESOLUTION

The only workaround is to use OLE DB Provider for ODBC and the Microsoft Oracle ODBC driver instead of OLE DB Provider for Oracle.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

Additional query words:

Keywords : kbADO kbDatabase kbOLEDB kbOracle kbProvider kbGrpVCDB kbGrpMDAC kbDSupport
Version : WINDOWS:2.0,2.1
Platform : WINDOWS
Issue type : kbbug