Devart Forums

• If Close() is called implicitly during instance disposal (by means of “using” construct), the errors simply get swallowed (no exception is thrown up to the caller), although exceptions still get thrown and caught internally, as one can see under debugger; looks like the implementation of Dispose() lacks GC.SuppressFinalize(), or sort of
• if OracleException is thrown due to constraints violation, its message contains a useless generic description ("ORA-24381: error(s) in array DML") instead of real error messages; see also http://forums.devart.com/viewtopic.php?f=1&t=29512
• the Error event is not triggered if not subscribed for immediately after an instance is created, e.g. after CreateColumns() has been called
• when Error event is called, the first argument of its delegate (“sender”) is not the loader instance (as one should expect), but some internal class with an obfuscated name (like “Devart.Data.Oracle.s”)

Dennis Wanke wrote:If Close() is called implicitly during instance disposal (by means of “using” construct), the errors simply get swallowed (no exception is thrown up to the caller), although exceptions still get thrown and caught internally, as one can see under debugger; looks like the implementation of Dispose() lacks GC.SuppressFinalize(), or sort of

Dennis Wanke wrote: if OracleException is thrown due to constraints violation, its message contains a useless generic description ("ORA-24381: error(s) in array DML") instead of real error messages; see also http://forums.devart.com/viewtopic.php?f=1&t=29512

static void Main(string[] args)
{
    OracleConnection connection = new OracleConnection("your connection string");
    connection.Open();

    OracleLoader loader = new OracleLoader();
    loader.Connection = connection;
    loader.Error += new OracleLoaderErrorEventHandler(loader_Error);
    loader.TableName = "table name";
    loader.CreateColumns();

    loader.Open();

    // Perform operations with Oracle Loader
    loader.Close();

}

static void loader_Error(object sender, OracleLoaderErrorEventArgs e)
{
    if (e.Exception.Errors == null)
        Console.WriteLine(e.Exception.Message);
    else
        foreach (OracleError error in e.Exception.Errors)
            Console.WriteLine(error.Message);
    e.Ignore = true;
}

Dennis Wanke wrote:the Error event is not triggered if not subscribed for immediately after an instance is created, e.g. after CreateColumns() has been called

Dennis Wanke wrote:when Error event is called, the first argument of its delegate (“sender”) is not the loader instance (as one should expect), but some internal class with an obfuscated name (like “Devart.Data.Oracle.s”)