Devart Forums

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 .

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?

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