Re: ORA-24381: error(s) in array DML, HELP

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 23 Mar 2005 22:51:15 +0100
Message-ID: <i3p34193ut4fca8sf6th9igpbkjrrg01gr@4ax.com>

On Wed, 23 Mar 2005 21:34:24 +0200, "wdewebserver" <wdecember_at_freemail.absa.co.za> wrote:

>Hi
>
>I am using ODP.NET to insert data into an Oracle database using the
>ArrayBind feature of ODP.NET. I can successfully inserted 51 892 records
>with no problems. I get the the following error when inserting 254 456
>records; "ORA-24381: error(s) in array DML".
>Can anyone tell me why I'm getting this error? Is there a limitation on the
>array size, if yes, what is it?
>
>TIA
>

Two questions:
- Which version
- Did you look up the error in the server messages manual. Probably you didn't.

Arrays are allocated in the pga. There are definitely limits to the pga, but they can only be changed in 9i and higher.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Mar 23 2005 - 15:51:15 CST