My Oracle Support Banner

Unable to Retrieve Complete Error Stack Through ODP.NET Interface (Doc ID 330214.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Data Provider for .NET - Version 10.1.0.4.0 and later
Information in this document applies to any platform.

Symptoms

When using ODP.NET and working with Oracle errors, only the first error in an error event is returned.

For example, examine the following error stack from SQL*Plus, which is one error event that contains two error messages:

     ORA-28003: password verification for the specified password failed
     ORA-20005: The password is too simple

In ODP.NET, the same error event would only return the following error stack:

     ORA-28003: password verification for the specified password failed

Even if you are checking for errors as follows...

 

 

' VB.NET Sample Code

...

Try 

  conn.OpenWithNewPassword(txNewPwd.Text) 

Catch ex As OracleException

   For Each oError In ex.Errors 
     MessageBox.Show(oError.Message.ToString()) 
   Next
...

you will only be able to return a single error and it will be the first error in the stack.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.