How to compare an Oracle exception message with a string?

Question

I am new to C# and I'm struggling with very basic stuff... for instance I am now trying to compare an exception that I KNOW will print exactly the phrase "ORA-28007: the password cannot be reused" if I use Response.Write(ex.Message). However, in the block below, the comparison between ex.Message and the string just provided fails and it returns that Unhandled Exception I've put in the else clause... How should I be comparing the exception with the string?

catch (Exception ex)
{
   if (ex.Message == "ORA-28007: the password cannot be reused")
   {
     Response.Write(ex.Message);
     // TODO : Correct the exception to be presented in the popup instead of the same page.
     // display = "The password cannot be reused! Pick a new one.";
     // ClientScript.RegisterStartupScript(this.GetType(), 
     //     "Error.", "alert('" + display + "');", true);
   }
   else
   {
     Response.Write("Unhandled exception: " + ex.Message);
   }
}

your error message may be slightly different. try ex.Message.Contains("ORA-28007") — L.B
– L.B, Commented Dec 23, 2016 at 19:06
normally Exceptions has an HResult property with a numeric value that you can check. — McNets
– McNets, Commented Dec 23, 2016 at 19:25
Why dont you put a break point on the If() statement and check the result of ex.Message in the debugger ? — PhillipH
– PhillipH, Commented Dec 23, 2016 at 19:27

Ruben Steins · Accepted Answer · 2016-12-23 19:30:54Z

6

If you're using the Oracle Data Provider for .NET you can catch OracleExceptions instead of Exceptions and get some more details by looking at the Errors property, which gives a list of OracleError objects:

catch(OracleException oex)
{
    foreach (OracleError error in oex.Errors) 
    {
        Console.WriteLine("Error Message: " + error.Message);
        Console.WriteLine("Error Source: " + error.Source);

        if(error.Number == 28007) 
        {
            // do specific stuff
        }       
     }
 }

answered Dec 23, 2016 at 19:30

Ruben Steins

2,8304 gold badges29 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bruno Carvalho Over a year ago

Thank you all for the answers and help! I used the tip from L.B (ex.Message.Contains("ORA-28007"))...

Collectives™ on Stack Overflow

How to compare an Oracle exception message with a string?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related