Skip to Main Content
Forums

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Maximum size when using array binding

377398Feb 28 2003 — edited Mar 22 2003
Hello,

I've got a very large amount of data to insert in a table, so I used array binding to get better performance.
My arrays are String[] and int[].
When I use arrays with a size of around 80.000 elements it does well but when I use arrays with more than 1.000.000 elements, I get an ORA-24381 error (Error in Array-DML).

Is it possible, that there is a maximum length for the arrays that can be used?

Thanks for your answers,
Christian
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2003
Added on Feb 28 2003
#odp-net
6 comments
6,614 views