Error with TCRBatchMove and Oracle Direct Mode

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
invent
Posts: 92
Joined: Tue 16 Jun 2009 10:59
Location: Bielefeld, Germany

Error with TCRBatchMove and Oracle Direct Mode

Post by invent » Thu 03 Nov 2011 17:47

Hi,

I made a small program which uses TCRBatchMove to copy data from one table to another. This works fine with InterBase and Sql-Server.

But it doesn't works with Oracle in direct mode. When I use CRBatchMove on a table with ~ 90.000 records, CRBatchMove stops after some time. In DBExplorer I only see something like "out of memory". I can get this error on different clients and with different Oracle-servers.

When I start this on a client with installed Oracle-client and set Oracle.Direct=False, the CRBatchMove works perfect.

It must be something with the direct mode.

I tried this with Delphi 7, UniDAC 3.50.013, InterBase XE, Oracle 8.0.5 and SQL-Server 2008 RC2.

Kind regards,
Gerd Brinkmann
invent GmbH

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Fri 04 Nov 2011 10:13

Hello,

We've fixed this problem. Please download the latest version of UniDAC (4.0.2) and try once more.

Post Reply