Page 1 of 1
ORA-24381: error(s) in array DML w/ Oracle Loader
Posted: Mon 16 Sep 2013 23:12
by NMH
How in the world do we debug this error? There are no additional details.
Please advise.
Re: ORA-24381: error(s) in array DML w/ Oracle Loader
Posted: Thu 19 Sep 2013 14:50
by 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);
}
Re: ORA-24381: error(s) in array DML w/ Oracle Loader
Posted: Thu 19 Sep 2013 15:37
by NMH
Thanks. Please consider adding this info into the documentation entry for OracleLoader.
Re: ORA-24381: error(s) in array DML w/ Oracle Loader
Posted: Fri 20 Sep 2013 14:47
by Pinturiccio
Thank you for your suggestion. We will add this information in our documentation.