The OracleException class represents an exception that is thrown when the Oracle Data Provider for .NET encounters an error. Each OracleException object contains at least one OracleError object in the Error property that describes the error or warning.
System.Object
System.Exception
System.SystemException
System.Runtime.InteropServices.ExternalException (ADO.NET 2.0 only)
System.Data.Common.DbException (ADO.NET 2.0 only)
Oracle.DataAccess.Client.OracleException
// C# public sealed class OracleException : SystemException
All public static methods are thread-safe, although instance methods do not guarantee thread safety.
If there are multiple errors, ODP.NET only returns the first error message on the stack.
// C#
using System;
using System.Data;
using Oracle.DataAccess.Client;
class OracleExceptionSample
{
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.");
Console.WriteLine("Exception Message: " + ex.Message);
Console.WriteLine("Exception Source: " + ex.Source);
}
}
}
Namespace: Oracle.DataAccess.Client
Assembly: Oracle.DataAccess.dll
ODP.NET Version: ODP.NET for .NET Framework 2.0 or ODP.NET for .NET Framework 4
See Also:
OracleException members are listed in the following tables.
OracleException Static Methods
The OracleException static method is listed in Table 5-62.
Table 5-62 OracleException Static Method
| Method | Description |
|---|---|
|
|
Inherited from |
OracleException properties are listed in Table 5-63.
Table 5-63 OracleException Properties
| Property | Description |
|---|---|
|
Specifies the TNS name that contains the information for connecting to an Oracle instance |
|
|
Specifies a collection of one or more |
|
|
|
Inherited from |
|
|
Inherited from |
|
Specifies the error messages that occur in the exception |
|
|
Specifies the Oracle error number |
|
|
Specifies the stored procedure that cause the exception |
|
|
Specifies the name of the data provider that generates the error |
|
|
|
Inherited from |
|
|
Inherited from |
OracleException methods are listed in Table 5-64.
Table 5-64 OracleException Methods
| Method | Description |
|---|---|
|
|
Inherited from |
|
|
Inherited from |
|
|
Inherited from |
|
Sets the serializable |
|
|
|
Inherited from |
|
Returns the fully qualified name of this exception |
The OracleException static method is listed in Table 5-65.
OracleException properties are listed in Table 5-66.
Table 5-66 OracleException Properties
| Property | Description |
|---|---|
|
Specifies the TNS name that contains the information for connecting to an Oracle instance |
|
|
Specifies a collection of one or more |
|
|
|
Inherited from |
|
|
Inherited from |
|
Specifies the error messages that occur in the exception |
|
|
Specifies the Oracle error number |
|
|
Specifies the stored procedure that cause the exception |
|
|
Specifies the name of the data provider that generates the error |
|
|
|
Inherited from |
|
|
Inherited from |
This property specifies the TNS name that contains the information for connecting to an Oracle instance.
// C#
public string DataSource {get;}
The TNS name containing the connect information.
This property specifies a collection of one or more OracleError objects that contain information about exceptions generated by the Oracle database.
// C#
public OracleErrorCollection Errors {get;}
An OracleErrorCollection.
The Errors property contains at least one instance of OracleError objects.
Overrides Exception
This property specifies the error messages that occur in the exception.
// C#
public override string Message {get;}
A string.
Message is a concatenation of all errors in the Errors collection. Each error message is concatenated and is followed by a carriage return, except the last one.
This property specifies the Oracle error number.
// C#
public int Number {get;}
The error number.
This error number can be the topmost level of error generated by Oracle and can be a provider-specific error number.
This property specifies the stored procedure that caused the exception.
// C#
public string Procedure {get;}
The stored procedure name.
OracleException methods are listed in Table 5-67.
Table 5-67 OracleException Methods
| Method | Description |
|---|---|
|
|
Inherited from |
|
|
Inherited from |
|
|
Inherited from System. |
|
Sets the serializable |
|
|
|
Inherited from |
|
Returns the fully qualified name of this exception |
Overrides Exception
This method sets the serializable info object with information about the exception.
// C# public override void GetObjectData(SerializationInfo info, StreamingContext context);
info
A SerializationInfo object.
context
A StreamingContext object.
The information includes DataSource, Message, Number, Procedure, Source, and StackTrace.
Overrides Exception
This method returns the fully qualified name of this exception, the error message in the Message property, the InnerException.ToString() message, and the stack trace.
// C# public override string ToString();
The string representation of the exception.
// C#
using System;
using Oracle.DataAccess.Client;
class ToStringSample
{
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(); // This will throw an exception
}
catch (OracleException ex)
{
Console.WriteLine("Record is not inserted into the database table.");
Console.WriteLine("ex.ToString() : " + ex.ToString());
}
}
}