ORA-24381: error(s) in array DML w/ Oracle Loader

ORA-24381: error(s) in array DML w/ Oracle Loader

Postby NMH » Mon 16 Sep 2013 23:12

How in the world do we debug this error? There are no additional details.

Please advise.
NMH
 
Posts: 9
Joined: Fri 07 Dec 2012 16:40

Re: ORA-24381: error(s) in array DML w/ Oracle Loader

Postby Pinturiccio » Thu 19 Sep 2013 14:50

When using OracleLoader, multiple rows can be inserted. More than one row can cause an error, and different rows can cause different exceptions when closing OracleLoader, that's why the "ORA-24381: error(s) in array DML w/ Oracle Loader" exception is raised.

You can process the list of errors raised when OracleLoader is closed. For this use the Error event. Here is the example:
Code: Select all
OracleLoader loader = new OracleLoader();
loader.Error += new OracleLoaderErrorEventHandler(loader_Error);
//work with OracleLoader
...

static void loader_Error(object sender, OracleLoaderErrorEventArgs e)
{
    foreach (OracleError error in e.Exception.Errors)
        Console.WriteLine(error.Message);
}
Pinturiccio
Devart Team
 
Posts: 1936
Joined: Wed 02 Nov 2011 09:44

Re: ORA-24381: error(s) in array DML w/ Oracle Loader

Postby NMH » Thu 19 Sep 2013 15:37

Thanks. Please consider adding this info into the documentation entry for OracleLoader.
NMH
 
Posts: 9
Joined: Fri 07 Dec 2012 16:40

Re: ORA-24381: error(s) in array DML w/ Oracle Loader

Postby Pinturiccio » Fri 20 Sep 2013 14:47

Thank you for your suggestion. We will add this information in our documentation.
Pinturiccio
Devart Team
 
Posts: 1936
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle