Export (0) Print
Expand All

OracleException Class

The exception that is generated when a warning or error is returned by an Oracle database or the .NET Framework Data Provider for Oracle. This class cannot be inherited.

Namespace: System.Data.OracleClient
Assembly: System.Data.OracleClient (in system.data.oracleclient.dll)

'Declaration
<SerializableAttribute> _
Public NotInheritable Class OracleException
	Inherits DbException
'Usage
Dim instance As OracleException

/** @attribute SerializableAttribute() */ 
public final class OracleException extends DbException
SerializableAttribute 
public final class OracleException extends DbException
Not applicable.

This class is created whenever the OracleDataAdapter encounters a situation that it cannot handle.

If the severity of the error is too great, the server may close the OracleConnection. However, the user can reopen the connection and continue.

The following example generates an OracleException due to a missing database, and then displays the exception.

Public Sub ShowOracleException() 

   Dim myConnection As OracleConnection = _
      New OracleConnection("Data Source=Oracle8i;Integrated Security=yes")

   Try 

      myConnection.Open()

   Catch e As OracleException

     Dim errorMessage As String = "Code: " & e.Code & vbCrLf & _
                                  "Message: " & e.Message

     Dim log As System.Diagnostics.EventLog = New System.Diagnostics.EventLog()
     log.Source = "My Application"
     log.WriteEntry(errorMessage)
     Console.WriteLine("An exception occurred. Please contact your system administrator.")

   End Try
End Sub

System.Object
   System.Exception
     System.SystemException
       System.Runtime.InteropServices.ExternalException
         System.Data.Common.DbException
          System.Data.OracleClient.OracleException

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Windows 98, Windows Server 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1

Community Additions

ADD
Show:
© 2014 Microsoft