OracleErrorCollection Class

An OracleErrorCollection class represents a collection of all errors that are thrown by the Oracle Data Provider for .NET.

Class Inheritance

System.Object

  System.ArrayList

    Oracle.DataAccess.Client.OracleErrorCollection

Declaration

// C#
public sealed class OracleErrorCollection : ArrayList

Requirements

Provider ODP.NET, Unmanaged Driver ODP.NET, Managed Driver
Assembly Oracle.DataAccess.dll Oracle.ManagedDataAccess.dll
Namespace Oracle.DataAccess.Client Oracle.ManagedDataAccess.Client
.NET Framework 3.5, 4.0, 4.5 4.0, 4.5

Thread Safety

All public static methods are thread-safe, although instance methods do not guarantee thread safety.

Remarks

A simple ArrayList that holds a list of OracleErrors.

If there are multiple errors, ODP.NET only returns the first error message on the stack.

Example

// C#
 
using System;
using System.Data;
using Oracle.DataAccess.Client;
 
class OracleErrorCollectionSample
{
  static void Main()
  {
    string constr = "User Id=scott;Password=tiger;Data Source=oracle";
    OracleConnection con = new OracleConnection(constr);
    con.Open();
 
    // Create an OracleCommand object using the connection object
    OracleCommand cmd = con.CreateCommand();
 
    try
    {
      cmd.CommandText = "insert into notable values (99, 'MyText')";
      cmd.ExecuteNonQuery();
    }
    catch (OracleException ex)
    {
      Console.WriteLine("Record is not inserted into the database table.");
 
      foreach (OracleError error in ex.Errors) 
      {
        Console.WriteLine("Error Message: " + error.Message);
        Console.WriteLine("Error Source: " + error.Source);         
      }
    }
  }
}

OracleErrorCollection Members

OracleErrorCollection members are listed in the following tables.

OracleErrorCollection Static Methods

OracleErrorCollection static methods are listed in Table 6-69.

Table 6-69 OracleErrorCollection Static Methods

Method Description

Equals

Inherited from System.Object (Overloaded)


OracleErrorCollection Properties

OracleErrorCollection properties are listed in Table 6-70.

Table 6-70 OracleErrorCollection Properties

Property Description

Capacity

Inherited from System.Collections.ArrayList

Count

Inherited from System.Collections.ArrayList

IsReadOnly

Inherited from System.Collections.ArrayList

IsSynchronized

Inherited from System.Collections.ArrayList

Item

Inherited from System.Collections.ArrayList


OracleErrorCollection Public Methods

OracleErrorCollection public methods are listed in Table 6-71.

Table 6-71 OracleErrorCollection Public Methods

Public Method Description

CopyTo

Inherited from System.Collections.ArrayList

Equals

Inherited from System.Object (Overloaded)

GetHashCode

Inherited from System.Object

GetType

Inherited from System.Object

ToString

Inherited from System.Object


OracleErrorCollection Static Methods

The OracleErrorCollection static method is listed in Table 6-72.

Table 6-72 OracleErrorCollection Static Method

Method Description

Equals

Inherited from System.Object (Overloaded)


OracleErrorCollection Properties

OracleErrorCollection properties are listed in Table 6-73.

Table 6-73 OracleErrorCollection Properties

Property Description

Capacity

Inherited from System.Collections.ArrayList

Count

Inherited from System.Collections.ArrayList

IsReadOnly

Inherited from System.Collections.ArrayList

IsSynchronized

Inherited from System.Collections.ArrayList

Item

Inherited from System.Collections.ArrayList


OracleErrorCollection Public Methods

OracleErrorCollection public methods are listed in Table 6-74.

Table 6-74 OracleErrorCollection Public Methods

Public Method Description

CopyTo

Inherited from System.Collections.ArrayList

Equals

Inherited from System.Object (Overloaded)

GetHashCode

Inherited from System.Object

GetType

Inherited from System.Object

ToString

Inherited from System.Object