Devart Forums

Hi Guys,


I am executing an InsertCommand.ExecuteArray for about (100,000) records into an Oracle Express database. I keep getting the following error:


Iters must be greater than one.

Does the ExecuteArray have a size limit????

I have no idea what this means. Can you help me with this?


Thanks,



Stephane Touya



PS> I am using the oraDirect.net component

You have to pass parameter value greater than 1 to ExecuteArray function. Please see OraDirect .NET documentation and ExecuteArray sample project for how to use ExecuteArray function.

Hello,

actually I think MrTouya is right, there probably is some (maybe unintentional) limit on ExecuteArray. I just tried to insert 271.530 values with one ExecuteArray Command (including 10 OracleParameters) and got the same "Iters must be greater than one" error. Then I found that thread and started to test further - with 100.000 records: same error. Then I splitted the 100.000 records into two halfs with succes: both halfs can be imported, so obviously, there's no problem with the data. My next guess was 2^16, but 65536 and 65535 didn't work ... it works for 65000, so the truth (for my test case) must be somewhere between 65000 and 65535.

btw. I'm using OraDirect 4.00.15 ...

best regards,

Martin

Could you please send me your test project, including the definition of your own database objects?
Use e-mail address provided in the Readme file.

Hi,

just sent the test project ...

greetings,

Martin

Thanks to your project I could reproduce the problem. With 65535 the sample doesn't work, but with 65534 it works. We will investigate the problem and I'll let you know the results.

We have analyzed the problem. This is a designed behavior, except error message. It should read

Iters must be less than 65535

This is fixed in the next version.

Thanks for analyzing - I think it'd be a good idea to add that limitation to the docs !

wbr,

Martin

Sure. You are right.