DML Arrays Maximum size

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tibishor_p
Posts: 3
Joined: Fri 05 Mar 2010 10:33
Contact:

DML Arrays Maximum size

Post by tibishor_p » Fri 05 Mar 2010 10:41

Hi everybody!
I have a big problem when using DML arrays with size 200.
My code is something like this:

BEGIN
INSERT INTO table values(:A1, :B1, :C1);
INSERT INTO table values(:A2, :B2, :C2);
INSERT INTO table values(:A3, :B3, :C3);
INSERT INTO table values(:A4, :B4, :C4);
END;

A1,..., C4 are variant arrays with size 200.
When I try to run this statements with a TOraSQL , I get all kind of access violations, invalid pointer errors and so on. Can any body help me with an answer?
P.S. Using smaller size arrays is not a solution for me :).

tibishor_p
Posts: 3
Joined: Fri 05 Mar 2010 10:33
Contact:

Hi again!

Post by tibishor_p » Fri 05 Mar 2010 11:47

The error I get most of the times is following:

Access violation at address 61C26908 in module 'OraClient11.Dll'. Read of address FFFFFFFF.

Can anyone explain what is the problem?

tobias_cd
Posts: 56
Joined: Thu 18 Dec 2008 22:10

Post by tobias_cd » Sat 06 Mar 2010 06:28

Hi,
I'm not sure if this may assist, but for example Oracle does not allow more than 1000 values in a "where xxx in (...)" list, maybe there is a similar restriction on amount of parameters as well in Oracle. Just a thought.
Regards,
Tobias

Post Reply