Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

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

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 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.