ExecuteArray Error. Iters must be greater than one.
ExecuteArray Error. Iters must be greater than one.
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
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
Hmmm
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
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