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

[NMH]

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

Please advise.

[Pinturiccio]

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);
}

[NMH]

Thanks. Please consider adding this info into the documentation entry for OracleLoader.

[Pinturiccio]

Thank you for your suggestion. We will add this information in our documentation.